1 The SAS System 07:09 Monday, September 5, 2016 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program (4)'; 4 %LET _CLIENTPROJECTPATH='path'; 5 %LET _CLIENTPROJECTNAME='name'; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 13 STYLE=HtmlBlue 14 STYLESHEET=(URL="path") 15 NOGTITLE 16 NOGFOOTNOTE 17 GPATH=&sasworklocation SYMBOLGEN: Macro variable SASWORKLOCATION resolves to "/path/" 18 ENCODING=UTF8 19 options(rolap="on") 20 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 21 22 GOPTIONS ACCESSIBLE; 23 %let local_Filename = File1 File2 'File3 File4'n; 24 %let Excel_table = Sheet1 Sheet2 'Third Sheet'n; 25 %let SAS_DATASET = Data1 data2 data3; 26 options SYMBOLGEN MPRINT; 27 %macro file_process; 28 %let word_cnt = %sysfunc(countW(&local_Filename)); 29 %do i = 1 %to &word_cnt; 30 %let file_name=%qscan(%bquote(&local_Filename),&i); 31 %let dataset=%qscan(%bquote(&SAS_DATASET),&i); 32 %let table=%qscan(%bquote(&Excel_table),&i); 33 libname xlsFile XLSX "/user/&file_name only.xlsm"; 34 PROC SQL; 35 create table work.&dataset as 36 (select * from xlsFile.'&table'n); 37 run; 38 %end; 39 %mend file_process; 40 %file_process; SYMBOLGEN: Macro variable LOCAL_FILENAME resolves to File1 File2 'File3 File4'n SYMBOLGEN: Macro variable WORD_CNT resolves to 4 SYMBOLGEN: Macro variable LOCAL_FILENAME resolves to File1 File2 'File3 File4'n SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable SAS_DATASET resolves to Data1 data2 data3 SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable EXCEL_TABLE resolves to Sheet1 Sheet2 'Third Sheet'n SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable FILE_NAME resolves to File1 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(FILE_PROCESS): libname xlsFile XLSX "/user/File1 only.xlsm"; NOTE: Libref XLSFILE was successfully assigned as follows: Engine: XLSX Physical Name: /user/File1 only.xlsm 2 The SAS System 07:09 Monday, September 5, 2016 MPRINT(FILE_PROCESS): PROC SQL; SYMBOLGEN: Macro variable DATASET resolves to Data1 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(FILE_PROCESS): create table work.Data1 as (select * from xlsFile.'&table'n); ERROR: File XLSFILE.'&table'n.DATA does not exist. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. MPRINT(FILE_PROCESS): run; SYMBOLGEN: Macro variable LOCAL_FILENAME resolves to File1 File2 'File3 File4'n SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable SAS_DATASET resolves to Data1 data2 data3 SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable EXCEL_TABLE resolves to Sheet1 Sheet2 'Third Sheet'n SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable FILE_NAME resolves to File2 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(FILE_PROCESS): libname xlsFile XLSX "/user/File2 only.xlsm"; NOTE: Libref XLSFILE was successfully assigned as follows: Engine: XLSX Physical Name: /user/File2 only.xlsm NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2016-09-05T08:19:34,026-04:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 21921792| _DISARM| 17981440| _DISARM| 11| _DISARM| 12| _DISARM| 0| _DISARM| 48136| _DISARM| 0.000000| _DISARM| 0.003759| _DISARM| 1788697174.022728| _DISARM| 1788697174.026487| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 264.46k OS Memory 17560.00k Timestamp 09/05/2016 08:19:34 AM Step Count 70 Switch Count 71 Page Faults 0 Page Reclaims 17 Page Swaps 0 Voluntary Context Switches 237 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 MPRINT(FILE_PROCESS): PROC SQL; SYMBOLGEN: Macro variable DATASET resolves to data2 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(FILE_PROCESS): create table work.data2 as (select * from xlsFile.'&table'n); ERROR: File XLSFILE.'&table'n.DATA does not exist. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. MPRINT(FILE_PROCESS): run; SYMBOLGEN: Macro variable LOCAL_FILENAME resolves to File1 File2 'File3 File4'n SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable SAS_DATASET resolves to Data1 data2 data3 SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable EXCEL_TABLE resolves to Sheet1 Sheet2 'Third Sheet'n SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable FILE_NAME resolves to 'File3 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(FILE_PROCESS): libname xlsFile XLSX "/user/'File3 only.xlsm"; 3 The SAS System 07:09 Monday, September 5, 2016 NOTE: Libref XLSFILE was successfully assigned as follows: Engine: XLSX Physical Name: /user/'File3 only.xlsm NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2016-09-05T08:19:34,031-04:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 21921792| _DISARM| 17981440| _DISARM| 11| _DISARM| 12| _DISARM| 0| _DISARM| 48144| _DISARM| 0.000000| _DISARM| 0.002247| _DISARM| 1788697174.028894| _DISARM| 1788697174.031141| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 269.25k OS Memory 17560.00k Timestamp 09/05/2016 08:19:34 AM Step Count 71 Switch Count 71 Page Faults 0 Page Reclaims 17 Page Swaps 0 Voluntary Context Switches 233 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 MPRINT(FILE_PROCESS): PROC SQL; SYMBOLGEN: Macro variable DATASET resolves to data3 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(FILE_PROCESS): create table work.data3 as (select * from xlsFile.'&table'n); ERROR: File XLSFILE.'&table'n.DATA does not exist. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. MPRINT(FILE_PROCESS): run; SYMBOLGEN: Macro variable LOCAL_FILENAME resolves to File1 File2 'File3 File4'n SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable SAS_DATASET resolves to Data1 data2 data3 SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable EXCEL_TABLE resolves to Sheet1 Sheet2 'Third Sheet'n SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable FILE_NAME resolves to File4'n SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(FILE_PROCESS): libname xlsFile XLSX "/user/File4'n only.xlsm"; NOTE: Libref XLSFILE was successfully assigned as follows: Engine: XLSX Physical Name: /user/File4'n only.xlsm NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2016-09-05T08:19:34,035-04:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 21921792| _DISARM| 17981440| _DISARM| 11| _DISARM| 12| _DISARM| 0| _DISARM| 48160| _DISARM| 0.010000| _DISARM| 0.002110| _DISARM| 1788697174.033870| _DISARM| 1788697174.035980| _DISARM| 0.010000| _DISARM| | _ENDDISARM NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 266.00k OS Memory 17560.00k Timestamp 09/05/2016 08:19:34 AM Step Count 72 Switch Count 67 Page Faults 0 Page Reclaims 17 4 The SAS System 07:09 Monday, September 5, 2016 Page Swaps 0 Voluntary Context Switches 217 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 MPRINT(FILE_PROCESS): PROC SQL; SYMBOLGEN: Macro variable DATASET resolves to SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-322: Syntax error, expecting one of the following: CHAR, CHARACTER, DATE, DEC, DECIMAL, DOUBLE, FLOAT, INT, INTEGER, NUM, NUMERIC, REAL, SMALLINT, VARCHAR. 76: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 76-322: Syntax error, statement will be ignored. MPRINT(FILE_PROCESS): create table work. as (select * from); NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. MPRINT(FILE_PROCESS): run; 41 42 43 GOPTIONS NOACCESSIBLE; 44 %LET _CLIENTTASKLABEL=; 45 %LET _CLIENTPROJECTPATH=; 46 %LET _CLIENTPROJECTNAME=; 47 %LET _SASPROGRAMFILE=; 48 49 ;*';*";*/;quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2016-09-05T08:19:34,041-04:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 21921792| _DISARM| 17981440| _DISARM| 11| _DISARM| 12| _DISARM| 0| _DISARM| 48168| _DISARM| 0.000000| _DISARM| 0.002558| _DISARM| 1788697174.039360| _DISARM| 1788697174.041918| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 34.25k OS Memory 17560.00k Timestamp 09/05/2016 08:19:34 AM Step Count 73 Switch Count 89 Page Faults 0 Page Reclaims 9 Page Swaps 0 Voluntary Context Switches 303 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 49 ! run; 50 ODS _ALL_ CLOSE; 51 52 53 QUIT; RUN; 54