DATA Step, Macro, Functions and more

Proc import excel read second row

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

Proc import excel read second row

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.

Accepted Solutions
Solution
‎04-06-2018 04:23 PM
Super User
Posts: 10,621

Re: Proc import excel read second row

If you want use these options

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

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

View solution in original post


All Replies
Super Contributor
Posts: 473

Re: Proc import excel read second row

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

Thanks,
Suryakiran
Solution
‎04-06-2018 04:23 PM
Super User
Posts: 10,621

Re: Proc import excel read second row

If you want use these options

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

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 100 views
  • 0 likes
  • 3 in conversation