I am outputting multiple procs through ODS to xml/Excel, results from different procs should be on separate worksheets, but all tables (results) from 1 proc freq with chisq should be on 1 worksheet. Currently, every table gets a separate worksheet. Here is the code:
ods _all_ close;
ods tagsets.ExcelXP path='filepath' file='filename.xml' style=printer;
options helpbrowser=sas;
* 1st worksheet;
ods tagsets.ExcelXP options(sheet_name='sheet1');
proc freq data=filename1;
table var1;
run;
quit;
* 2nd worksheet;
ods tagsets.ExcelXP options(sheet_name='sheet2');
proc freq data=filename1;
table var1*var2 /chisq;
run;
quit;
ods tagsets.ExcelXP close;
I tried adding the following to no avail:
options(sheet_interval='Proc');
Sheet interval is correct.
Post the full code with Sheet_Interval - preferably using a SASHELP dataset so we can run and test as well.
Sheet interval is correct.
Post the full code with Sheet_Interval - preferably using a SASHELP dataset so we can run and test as well.
Thank you for the confirmation. I had the option in the wrong spot. It works:
ods _all_ close;
ods tagsets.ExcelXP path='filepath' file='filename.xml' style=printer
options(sheet_interval='Proc');
options helpbrowser=sas;
* 1st worksheet;
ods tagsets.ExcelXP options(sheet_name='sheet1');
proc freq data=filename1;
table var1;
run;
quit;
* 2nd worksheet;
ods tagsets.ExcelXP options(sheet_name='sheet2');
proc freq data=filename1;
table var1*var2 /chisq;
run;
quit;
ods tagsets.ExcelXP close;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.