Does anyone know of a way to specify different ranges in Proc Import?
For example, if I have the labels on row 2 and the data doesn't
actually start until row 15, is there a way to skip rows 3-14?

Thank you

data excel;
   set excel;
   row=_n_;
run;

proc sql;
   delete from excel
   where row LT 15;
quit;

Deleting rows is easy, but what if you don't want to read them, as it
can change the format that Proc Import reads?  If the first 15 rows
are missing, or are filled with notes, and you only have 10 rows of
actual data to read in, then the data is set to character even if the
data are all numerical, as the majority of values are now character.
When you are reading in multiple excel sheets, and some have these
note rows, is there a way to skip the note rows to avoid multiple
character to numeric changes?

This should work - use getnames for the labels and datarow for the
data.

proc import datafile="c:\My Spreadsheet.xls"
			dbms=xls
			out=NewDataSet
			replace
			;
	sheet="Sheet1";
	getnames=Yes;
	datarow=15;
run;