03-25-2013 07:10 AM
I am trying to import multiple excel sheets to get different ouput datasets,....
Please check and help ...what's wrong in my approach??
PROC IMPORT DATAFILE="&IMP" DBMS=EXCEL OUT=&OUT_DAT REPLACE;
NOTE: Data source is connected in READ ONLY mode.
ERROR: File _IMEX_.'EXL_SHT$'n.DATA does not exist.
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.96 seconds
cpu time 0.56 seconds
03-25-2013 07:28 AM
There are a bunch of SAS notes regarding this error message. I suggest that you first look thru these.
Another way to do this is to use the Libname Excel engine instead, then there is no need for looping thru the different sheets with a macro call.