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-2024.png

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.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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