When I use PROC IMPORT to import Excel files, I got the errors as shown below:
Code:
proc import
out = Variable
datafile = "&inputPath./&varfile."
DBMS=XLSX REPLACE;
GETNAMES=yes;
/* DATAROW = 2; */
GUESSINGROWS=500;
MIXED=YES;
run;
SAS LOG:
23 proc import
24 out = Variable
25 datafile = "&inputPath./&varfile."
26 DBMS=XLSX REPLACE;
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
27 GETNAMES=yes;
28 /* DATAROW = 2; */
29 GUESSINGROWS=500;
____________
180
30 MIXED=YES;
_____
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
31 run;
This code works fine in PC SAS, but the error keeps coming out when I run this code in SAS EG. If I comment out thoes two options "GUESSINGROWS=" and "MIXED=", then there is no errors.
Does anyone has any idea what causes this error and how to solve this problem?
Thank you
Guessingrows only applies to text type file formats such as CSV.
Depending on version of SAS EG the MIXED option doesn't work with later versions of Excel 2007 or later.
Are you executing the exact same code in PC SAS and EG?
Version of PC SAS?
Do you access the same PC SAS from EG, or do you use a WorkSpace Server (host and SAS version?)
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.