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.
If you want use these options
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
Try Save As your "test 1.xlsx" into "test1.xls" .
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
If you want use these options
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
Try Save As your "test 1.xlsx" into "test1.xls" .
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.