ODS Tagsets.ExcelXP - Controlling output on single and multiple sheets

[akj]

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');

[Reeza · Accepted solution]

Sheet interval is correct. 

Post the full code with Sheet_Interval - preferably using a SASHELP dataset so we can run and test as well.

[akj]

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;