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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.