https://communities.sas.com/t5/ODS-and-Base-Reporting/Outputting-to-multiple-excel-workbooks/m-p/5041#M2036 Is there a way of creating an excel <B>workbook</B> for each change in the value of the by variable in proc report?<BR /> <BR /> Any help would be much appreciated.<BR /> <BR /> Thanks Thu, 11 Oct 2007 10:15:19 GMT deleted_user 2007-10-11T10:15:19Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Outputting-to-multiple-excel-workbooks/m-p/5041#M2036 Is there a way of creating an excel <B>workbook</B> for each change in the value of the by variable in proc report?<BR /> <BR /> Any help would be much appreciated.<BR /> <BR /> Thanks Thu, 11 Oct 2007 10:15:19 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Outputting-to-multiple-excel-workbooks/m-p/5041#M2036 deleted_user 2007-10-11T10:15:19Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Outputting-to-multiple-excel-workbooks/m-p/5042#M2037 Hi:<BR /> You could investigate the NEWFILE= option, which works with most Markup destinations. <BR /> <BR /> With this code, I get 1 file for each by group: msrep1.xls thru msrep10.xls for the MSOFFICE2K HTML files and xprep1.xls thru xprep10.xls for the TAGSETS.EXCELXP XML files (using SASHELP.SHOES).<BR /> <BR /> cynthia<BR /> <BR /> [pre]<BR /> ods msoffice2k file='c:\temp\msrep1.xls' style=sasweb newfile=bygroup;<BR /> ods tagsets.excelxp file='c:\temp\xprep1.xls' style=sasweb newfile=bygroup;<BR /> <BR /> proc report data=sashelp.shoes nowd;<BR /> title 'Report for #byval(region)';<BR /> by region;<BR /> column region product sales;<BR /> define region /group;<BR /> define product /group;<BR /> define sales /sum;<BR /> rbreak after / summarize;<BR /> run;<BR /> <BR /> ods _all_ close;<BR /> [/pre] Thu, 11 Oct 2007 14:09:27 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Outputting-to-multiple-excel-workbooks/m-p/5042#M2037 Cynthia_sas 2007-10-11T14:09:27Z