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
SAS Super FREQ
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

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

Register now!

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
  • 941 views
  • 0 likes
  • 2 in conversation