Hello, Here's an example of a problem I'm trying to solve: %let path=path_here\;
ods noproctitle;
ods Excel file="&path.sashelp.xlsx" style=analysis options (sheet_interval="none" embedded_titles="yes");
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~;;
ods excel options(sheet_name="birthweight");
title "race";
proc freq data=SASHELP.BIRTHWGT;
tables race/missing nocol nocum norow nopercent;
run;
title "married";
proc freq data=SASHELP.BIRTHWGT;
tables married/missing nocol nocum norow nofreq;
run;
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~;;
ods excel options(sheet_name="citiyr,cntainer" sheet_interval="now");
title "CITIYR";
proc print data=SASHELP.CITIYR noobs;
title "CNTAINER";
proc print data=SASHELP.CNTAINER noobs;
ods excel options(sheet_name="birthweight2" sheet_interval="now");
title "race";
proc freq data=SASHELP.BIRTHWGT;
tables race/missing nocol nocum norow nopercent;
run;
ods excel close; As you can see on the last tab, one of the tables gets pushed to the wrong tab, and gets the wrong title. I've tried so many things, especially with the sheet_interval, but I'm always getting mixed-up tables.
... View more
