%macro import_top100(dat);
PROC IMPORT OUT= &dat
DATAFILE= "&lkp.\Topprescriber_lkup.xls"
DBMS=EXCEL REPLACE;
SHEET="&dat";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
%mend;
%import_top100(Physician_lookup);
In the above procedure ,do we have an option to let SAS know from which row it should start reading the data?
Say for instance, the first five rows in the excel gives infomation or some notes, and the actual data starts from sixth row, how do we process it?