Hi, I'm new to this. Please help me. I'm trying to proc import like this: proc import datafile='/folders/myfolders/desksas.xls' dbms=xls
out=work replace;
sheet='desksas';
getnames=yes;
run; but when I run it, the log result I got is like this: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 proc import datafile='/folders/myfolders/desksas.xls' dbms=xls
74 out=work replace;
75 sheet='desksas';
76 getnames=yes;
77 run;
Spreadsheet isn't from Excel V5 or later. Please open it in Excel and Save as V5 or later
Requested Input File Is Invalid
ERROR: Import unsuccessful. See SAS Log for details.
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
78
79
80 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
92 Can somebody help me with this?
... View more
