Hi folks, I need to generate an Excel file with more than one sheet. In each sheet, I have multiples reports (generated by proc tabulate), one below other. It's very important that the reports are one below other. I tried the following code but it generates one sheet only with all reports (one below other) and not two sheets as required. ODS EXCEL FILE="/Test.xlsx"
OPTIONS(START_AT="1,3" SHEET_INTERVAL="none" EMBED_TITLES_ONCE='yes' embedded_titles="yes" SHEET_NAME="Archivo 1") STYLE=Daisy;
/*Report 1*/
PROC TABULATE DATA=SASHELP.CLASS ;
VAR Age;
CLASS Sex / ORDER=UNFORMATTED MISSING;
TABLE Sex,
N
Age*Sum ;
RUN;
/*Report 2*/
PROC TABULATE DATA=SASHELP.CLASS ;
VAR Age;
CLASS Sex / ORDER=UNFORMATTED MISSING;
TABLE Sex,
N
Age*Sum ;
RUN;
ODS EXCEL OPTIONS (START_AT="1,3" SHEET_INTERVAL="none" EMBED_TITLES_ONCE='yes' embedded_titles="yes" SHEET_NAME="Archivo 2") STYLE=Daisy;
/*Report 3*/
PROC TABULATE DATA=SASHELP.CLASS ;
VAR Age;
CLASS Sex / ORDER=UNFORMATTED MISSING;
TABLE Sex,
N
Age*Sum ;
RUN;
/*Report 4*/
PROC TABULATE DATA=SASHELP.CLASS ;
VAR Age;
CLASS Sex / ORDER=UNFORMATTED MISSING;
TABLE Sex,
N
Age*Sum ;
RUN;
ODS _ALL_ CLOSE; I tried removing the option SHEET_INTERVAL="none" but it generate a sheet per proc tabulate, instead only two sheets. Any suggestion?
... View more
