Help using Base SAS procedures

ODS tagsets .excelXP

Reply
TK
N/A
Posts: 1

ODS tagsets .excelXP

hi
i'm trying to create one worksheet using two proc tabulate steps ,ODS Tagsets.ExcelXP..
SAS Super FREQ
Posts: 8,868

Re: ODS tagsets .excelXP

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
Ask a Question
Discussion stats
  • 1 reply
  • 150 views
  • 0 likes
  • 2 in conversation