Since you must have access to a copy of Excel to use the DBMS=EXCEL option in PROC IMPORT use it to save the file as an XLSX file and IMPORT the new file using the XLSX engine instead.
1047 proc import file="~/test/test.xlsx" dbms=xlsx out=test replace;
1048 getnames = no;
1049 range = "sheet$A6:c53";
1050 run;
NOTE: The import data set has 48 observations and 3 variables.
NOTE: WORK.TEST data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.13 seconds
cpu time 0.02 seconds
1051 data _null_;
1052 set test;
1053 if b ne int(b) then do;
1054 put (_n_ _all_) (=);
1055 stop;
1056 end;
1057 run;
_N_=1 A=8701.4623591 B=5.2105 C=21718.04648
NOTE: There were 1 observations read from the data set WORK.TEST.
... View more
