topic Re: Errors in PROC IMPORT of Excel files in SAS EG in SAS Enterprise Guide

Errors in PROC IMPORT of Excel files in SAS EG

Meng_Xu — Tue, 08 Mar 2016 21:10:26 GMT

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.

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

Re: Errors in PROC IMPORT of Excel files in SAS EG

ballardw — Tue, 08 Mar 2016 21:41:06 GMT

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.

Re: Errors in PROC IMPORT of Excel files in SAS EG

LinusH — Wed, 09 Mar 2016 09:05:30 GMT

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