topic Re: Proc import excel read second row in SAS Programming

Proc import excel read second row

mhollifi — Thu, 05 Apr 2018 20:15:39 GMT

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.

Re: Proc import excel read second row

SuryaKiran — Thu, 05 Apr 2018 20:31:45 GMT

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

Re: Proc import excel read second row

Ksharp — Fri, 06 Apr 2018 10:18:25 GMT

If you want use these options

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

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