Hi All, I am very new to SAS and I am stuck at trying to write a code (within a macro) which generates a seperate excel workbook for each outputed SAS dataset. I have managed to write a code which puts all of the datasets into a single workbook (in different tabs), but as outputs might get quite large the single workbook will become too heavy to work with. Here is the code that I have: ODS TAGSETS.EXCELXP FILE=&PATH STYLE=STATISTICAL
OPTIONS(FROZEN_ROWHEADERS='YES' SHEET_NAME="SEL"
AUTOFILTER='ALL');
%DO K=1 %TO #
PROC PRINT DATA= SEL&K;
RUN;
%END;
ODS TAGSETS.EXCELXP CLOSE; The &NUM variable represents the final line of my conditions file (I have a conditions table with 1-30 rows e.g. it might have 10, 15, 5 rows etc.) so the code at the moment is telling SAS to create as many tabs in the excel workbook according to the number of rows in my conditions table. The above code is part of a bigger Macro. Here is the code that I have in order to generate the NUM variable: DATA _NULL_;
SET _CH1 END=EOF;
IF EOF THEN CALL SYMPUTX('NUM',_N_);
RUN; The version of SAS that I am using is: SAS Enterprise Guide 7.1 (64-bit). Any help on how to put each dataset in a seperate workbook instead of into a single workbook, so that i end up with 1 to n different workbooks will be much appreciated. Kind regards, Todor
... View more