Proc import excel read second row

[mhollifi]

I tried to read an excel file from second line.  I got this error message.  What did I do wrong?

PROC IMPORT OUT= WORK.managers 
            DATAFILE= "e:\Users\mhollifi\Desktop\MaxWell read excel\test
1.xlsx" 
            DBMS=EXCEL REPLACE;
           GETNAMES=YES;
     RANGE="Request 5$A2:0"; 
     MIXED=NO;
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;

ERROR: File _IMEX_.'Request 5$A2:0'n.DATA does not exist.
ERROR: Import unsuccessful.  See SAS Log for details.

[SuryaKiran]

PROC IMPORT OUT= WORK.managers 
            DATAFILE= "e:\Users\mhollifi\Desktop\MaxWell read excel\test
1.xlsx" 
            DBMS=EXCEL REPLACE;
           GETNAMES=YES;
     DATAROW=2; 
     MIXED=NO;
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;

Use DATAROW=2

[Ksharp · Accepted solution]

If you want use these options

  MIXED=NO;
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;

Try Save As your "test 1.xlsx" into "test1.xls"  .