There are 12 sheets(from lab1 to lab12) in one excel file.
I want to transfer lab1 to sas data set . The program is following :
libname certadv xlsx 'C:\SAS data and program\data\data set used in OG of SAS adv\certadv\jijing.xlsx';
data certadv.lab1;
set certadv.'Lab1'n;
run;
proc print data = certadv.lab1;
run;
There are error note in the log:
67 libname certadv xlsx 'C:\SAS data and program\data\data set used in OG of SAS 67 ! adv\certadv\jijing.xlsx'; NOTE: Libref CERTADV was successfully assigned as follows: Engine: XLSX Physical Name: C:\SAS data and program\data\data set used in OG of SAS adv\certadv\jijing.xlsx 68 data certadv.lab1; 69 set certadv.'Lab1'n; ERROR: Couldn't find range or sheet in spreadsheet ERROR: File CERTADV.Lab1.DATA does not exist. 70 run;
There are no variables for the output file ERROR: File CERTADV.lab1.DATA does not exist. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set CERTADV.lab1 was only partially opened and will not be saved. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
71 proc print data = certadv.lab1; ERROR: Couldn't find range or sheet in spreadsheet ERROR: File CERTADV.lab1.DATA does not exist. 72 run;
NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
******************************************************************************
Please tell me how to correct my program , Thank you .
... View more