The SAS Output Delivery System and reporting techniques

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

Accepted Solution Solved
Reply
Occasional Contributor akj
Occasional Contributor
Posts: 5
Accepted Solution

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

[ Edited ]

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

 

 

 


Accepted Solutions
Solution
‎05-23-2017 03:35 PM
Super User
Posts: 19,789

Re: ODS xml proc freq / chisq - how to keep it output together on 1 page in Excel?

Sheet interval is correct. 

 

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

View solution in original post


All Replies
Solution
‎05-23-2017 03:35 PM
Super User
Posts: 19,789

Re: ODS xml proc freq / chisq - how to keep it output together on 1 page in Excel?

Sheet interval is correct. 

 

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

Occasional Contributor akj
Occasional Contributor
Posts: 5

Re: ODS xml proc freq / chisq - how to keep it output together on 1 page in Excel?

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;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 194 views
  • 1 like
  • 2 in conversation