And the error: SYMBOLGEN: Macro variable OUTLIB resolves to HSMR SYMBOLGEN: Macro variable YEAR resolves to 012020 SYMBOLGEN: Macro variable SUBSET resolves to surgical MPRINT(HSMR_QTR_GRP_GRP3_SUBSET): proc print data = HSMR.hsmr_qtr_012020_surgical noobs; MPRINT(HSMR_QTR_GRP_GRP3_SUBSET): title "HSMR, updated methodology - Subsets"; SYMBOLGEN: Macro variable YEAR resolves to 012020 SYMBOLGEN: Macro variable VAR3 resolves to unique_id SYMBOLGEN: Macro variable VAR resolves to program MPRINT(HSMR_QTR_GRP_GRP3_SUBSET): title2 "Year: 012020, Unit: unique_id, program"; SYMBOLGEN: Macro variable SUBSET resolves to surgical MPRINT(HSMR_QTR_GRP_GRP3_SUBSET): title3 "Subset = surgical"; MPRINT(HSMR_QTR_GRP_GRP3_SUBSET): run; WARNING: No output destinations active. NOTE: There were 86 observations read from the data set HSMR.HSMR_QTR_012020_SURGICAL. NOTE: PROCEDURE PRINT used (Total process time): real time 0.11 seconds cpu time 0.01 seconds MLOGIC(HSMR_QTR_GRP_GRP3_SUBSET): Ending execution. MPRINT(RUN_SURGICAL): ; 26191 +title ' '; MPRINT(RUN_SURGICAL): title ' '; 26191 !+ title2 ' '; MPRINT(RUN_SURGICAL): title2 ' '; 26191 !+ title3 ' '; MPRINT(RUN_SURGICAL): title3 ' '; 26192 +ods html close; MPRINT(RUN_SURGICAL): ods html close; MPRINT(RUN_SURGICAL): Run; MPRINT(RUN_SURGICAL): *** Output 3 ***; 26193 +Run; 26194 +*** Output 3 ***; 26195 +%let _outputnum=3;%HTMLFile_Out; MLOGIC(HTMLFILE_OUT): Beginning execution. SYMBOLGEN: Macro variable _OUTPUT_DIR resolves to \\grh202\HSMR\SAS\HSMR Code_June 2015_Batch\Output\ SYMBOLGEN: Macro variable _FILESUBSET resolves to SURGICAL SYMBOLGEN: Macro variable _RUN resolves to Run3 SYMBOLGEN: Macro variable _OUTPUTNUM resolves to 3 MPRINT(HTMLFILE_OUT): ods html file = "\\grh202\HSMR\SAS\HSMR Code_June 2015_Batch\Output\HSMR_SURGICAL_Run3_Output3.xls"; NOTE: Writing HTML Body file: \\grh202\HSMR\SAS\HSMR Code_June 2015_Batch\Output\HSMR_SURGICAL_Run3_Output3.xls ERROR: Physical file does not exist, C:\Users\username\AppData\Local\Temp\SAS Temporary Files\_TD9972_HLRC4095_\\\grh202\HSMR\SAS\HSMR Code_June 2015_Batch\Output\HSMR_SURGICAL_Run3_Output3.xls. ERROR: No body file. HTML output will not be created. MLOGIC(HTMLFILE_OUT): Ending execution. MPRINT(RUN_SURGICAL): ; 26196 +proc freq data=subset; MPRINT(RUN_SURGICAL): proc freq data=subset; SYMBOLGEN: Macro variable SUBSET resolves to surgical 26197 +title "Distribution of variables of interest in &subset. subgroup"; MPRINT(RUN_SURGICAL): title "Distribution of variables of interest in surgical subgroup"; 26198 +tables charlson_group transfer_in diag_flag_cancer diag_flag_renal diag_flag_stroke 26198 !+diag_flag_sepsis; MPRINT(RUN_SURGICAL): tables charlson_group transfer_in diag_flag_cancer diag_flag_renal diag_flag_stroke diag_flag_sepsis; 26199 +run; MPRINT(RUN_SURGICAL): run; WARNING: No output destinations active. NOTE: There were 86 observations read from the data set WORK.SUBSET. NOTE: PROCEDURE FREQ used (Total process time): real time 0.03 seconds cpu time 0.01 seconds ... View more

libname HSMR "\\Grh202\hsmr\SAS\SAS_datasets"; * Enter your HSMR data directory ; libname COEFFS "\\Grh202\hsmr\SAS"; * Enter the directory with the 6 SAS coefficient data files ; %let _SASCode_Dir =\\grh202\HSMR\SAS\HSMR Code_June 2015_Batch; * Enter the directory where the 7 BATCH SAS procedure code files are located (no quotes for this one); %let _Output_Dir =\\grh202\HSMR\SAS\HSMR Code_June 2015_Batch\Output; * Enter the directory for the output spreadsheet files ; %let _Input_Data =sacrs.jan2020; * Enter name (library.member) of the SAS data file you imported from Crystal Reports for this time period; ******************************* Overall labels for this time period - These are only used to label the output - they do not subset the analyses *******************************; %let year = 012020; * Enter time period abreviation (up to 7 characters maximum) ; %let date_run = 0417; * Enter the date you are running these analyses (maximum 4 characters) ; ******************************* Macros and Data processing *******************************; %Macro _bb;%include "&_SASCode_Dir.BATCH_HSMR_Macros.sas";Run;%Mend;%_bb; *This loads the BATCH macros and processes the data (nothing to change here)*; *******************************   ... View more

I've done this and it works ... View more