https://communities.sas.com/t5/ODS-and-Base-Reporting/excelxp-multiple-tabs/m-p/16782#M3501 It works fine now. Thanks! Thu, 24 Feb 2011 15:42:45 GMT deleted_user 2011-02-24T15:42:45Z https://communities.sas.com/t5/ODS-and-Base-Reporting/excelxp-multiple-tabs/m-p/16780#M3499 I'm trying to create a report with multiple tabs for each proc report step but instead keep getting multiple workbooks. I've read several postings but none seem to solve my problem. Currently I am running SAS 9.2 and already downloaded the most recent excelxp tagset definitions. Below is my code. Any ideas on how to get this to work would be greatly appreciated.<BR /> <BR /> ods tagsets.excelxp <BR /> file="file.xls"<BR /> style=sansprinter;<BR /> <BR /> ods tagsets.excelxp options(sheet_interval='none' sheet_name='First sheet');<BR /> <BR /> proc report data=&amp;lib..file1 nowd;<BR /> column stat_cd year_range, (accounts loans);<BR /> define year_range / across ;<BR /> define stat_cd / group;<BR /> define accounts / analysis format=18.;<BR /> define loans / analysis format=18.;<BR /> run;<BR /> <BR /> ods tagsets.excelxp options(sheet_interval='none' sheet_name='Second sheet');<BR /> <BR /> proc report data=work.file2 nowd;<BR /> column stat_cd year_range, (accounts loans);<BR /> define year_range / across ;<BR /> define stat_cd / group;<BR /> define accounts / analysis format=18.;<BR /> define loans / analysis format=18.;<BR /> run;<BR /> <BR /> ods tagsets.excelxp options(sheet_interval='none' sheet_name='Third sheet');<BR /> proc report data=work.file3 nowd;<BR /> column stat_cd year_range, (accounts loans);<BR /> define year_range / across ;<BR /> define stat_cd / group;<BR /> define accounts / analysis format=18.;<BR /> define loans / analysis format=18.;<BR /> run;<BR /> <BR /> ods tagsets.excelxp close; Thu, 24 Feb 2011 14:18:21 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/excelxp-multiple-tabs/m-p/16780#M3499 deleted_user 2011-02-24T14:18:21Z https://communities.sas.com/t5/ODS-and-Base-Reporting/excelxp-multiple-tabs/m-p/16781#M3500 hello,<BR /> <BR /> <P>use <B>newfile=none</B> on the ods tagsets.excelxp <BR /> file="file.xls"<BR /> style=sansprinter;<BR /> </P><BR /> <BR /> Marius Thu, 24 Feb 2011 15:12:44 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/excelxp-multiple-tabs/m-p/16781#M3500 deleted_user 2011-02-24T15:12:44Z https://communities.sas.com/t5/ODS-and-Base-Reporting/excelxp-multiple-tabs/m-p/16782#M3501 It works fine now. Thanks! Thu, 24 Feb 2011 15:42:45 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/excelxp-multiple-tabs/m-p/16782#M3501 deleted_user 2011-02-24T15:42:45Z