SAS online documentation lists three statements available for importing Excel files using DBMS=XLSX. They are GETNAMES, RANGE, and SHEET.
I tried adding the MIXED and TEXTSIZE statements to some PROC IMPORT code that normally works for me, and I see the same errors.
%let in_path=H:\CenSAS stuff;
proc import out=temp_class
datafile="&in_path\export_single_sheet_to_Excel.xlsx"
dbms=xlsx replace;
mixed=yes;
textsize=200;
run;
48 %let in_path=H:\CenSAS stuff;
49
50 proc import out=temp_class
51 datafile="&in_path\export_single_sheet_to_Excel.xlsx"
52 dbms=xlsx replace;
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
53 mixed=yes;
-----
180
54 textsize=200;
--------
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
55 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
If I don't use the MIXED and TEXTSIZE statements, the PROC IMPORT works as expected.
%let in_path=H:\CenSAS stuff;
proc import out=temp_class
datafile="&in_path\export_single_sheet_to_Excel.xlsx"
dbms=xlsx replace;
run;
56 %let in_path=H:\CenSAS stuff;
57
58 proc import out=temp_class
59 datafile="&in_path\export_single_sheet_to_Excel.xlsx"
60 dbms=xlsx replace;
61 run;
NOTE: The import data set has 19 observations and 5 variables.
NOTE: WORK.TEMP_CLASS data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.10 seconds
cpu time 0.00 seconds
