Errors in PROC IMPORT of Excel files in SAS EG

[Meng_Xu]

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

[ballardw]

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.

[LinusH]

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?)