ODS tagsets .excelXP

[TK]

hi
i'm trying to create one worksheet using two proc tabulate steps ,ODS Tagsets.ExcelXP..

[Cynthia_sas]

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