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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.