BookmarkSubscribeRSS Feed
TK
Calcite | Level 5 TK
Calcite | Level 5
hi
i'm trying to create one worksheet using two proc tabulate steps ,ODS Tagsets.ExcelXP..
1 REPLY 1
Cynthia_sas
Diamond | Level 26
Hi:
I'm not sure I understand your question. If you want both TABULATE outpus on one worksheet (instead of separate worksheets) then you would need to use the sheet_interval='none' suboption when you invoke TAGSETS.EXCELXP. To see the list of suboptions that you can use with TAGSETS.EXCELXP, submit the following code:
[pre]
ods tagsets.excelxp file='nooutput.xml' options(doc='help');
ods tagsets.excelxp close;
[/pre]

Or you could switch to ODS MSOFFICE2K because, by default, with HTML output (such as that created by ODS MSOFFICE2K) all the output automatically goes onto 1 worksheet).

Excel can open either output -- the XML created by TAGSETS.EXCELXP or the HTML created by MSOFFICE2K.

cynthia

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 1 reply
  • 1095 views
  • 0 likes
  • 2 in conversation