https://communities.sas.com/t5/SAS-Procedures/ODS-tagsets-excelXP/m-p/20482#M4239 Hi:<BR /> 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:<BR /> [pre]<BR /> ods tagsets.excelxp file='nooutput.xml' options(doc='help');<BR /> ods tagsets.excelxp close;<BR /> [/pre]<BR /> <BR /> 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).<BR /> <BR /> Excel can open either output -- the XML created by TAGSETS.EXCELXP or the HTML created by MSOFFICE2K.<BR /> <BR /> cynthia Thu, 21 Oct 2010 14:48:23 GMT Cynthia_sas 2010-10-21T14:48:23Z https://communities.sas.com/t5/SAS-Procedures/ODS-tagsets-excelXP/m-p/20481#M4238 hi<BR /> i'm trying to create one worksheet using two proc tabulate steps ,ODS Tagsets.ExcelXP.. Thu, 21 Oct 2010 14:08:19 GMT https://communities.sas.com/t5/SAS-Procedures/ODS-tagsets-excelXP/m-p/20481#M4238 TK 2010-10-21T14:08:19Z https://communities.sas.com/t5/SAS-Procedures/ODS-tagsets-excelXP/m-p/20482#M4239 Hi:<BR /> 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:<BR /> [pre]<BR /> ods tagsets.excelxp file='nooutput.xml' options(doc='help');<BR /> ods tagsets.excelxp close;<BR /> [/pre]<BR /> <BR /> 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).<BR /> <BR /> Excel can open either output -- the XML created by TAGSETS.EXCELXP or the HTML created by MSOFFICE2K.<BR /> <BR /> cynthia Thu, 21 Oct 2010 14:48:23 GMT https://communities.sas.com/t5/SAS-Procedures/ODS-tagsets-excelXP/m-p/20482#M4239 Cynthia_sas 2010-10-21T14:48:23Z