BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
akj
Fluorite | Level 6 akj
Fluorite | Level 6

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

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

2 REPLIES 2
Reeza
Super User

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
Fluorite | Level 6 akj
Fluorite | Level 6

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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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