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
... View more