https://communities.sas.com/t5/SAS-Enterprise-Guide/stored-Process-in-Excel-page-breaks/m-p/47032#M5282 I have a stored process that I'm using to output data into excel with multiple tabs<BR /> <BR /> To make it simple I use a proc print with a pageby<BR /> <BR /> one of the by variables has too many lines of output and I'm getting a pagebreak in the sheet. Is there any way to avoid this? Wed, 08 Dec 2010 19:19:34 GMT wkossack 2010-12-08T19:19:34Z https://communities.sas.com/t5/SAS-Enterprise-Guide/stored-Process-in-Excel-page-breaks/m-p/47032#M5282 I have a stored process that I'm using to output data into excel with multiple tabs<BR /> <BR /> To make it simple I use a proc print with a pageby<BR /> <BR /> one of the by variables has too many lines of output and I'm getting a pagebreak in the sheet. Is there any way to avoid this? Wed, 08 Dec 2010 19:19:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/stored-Process-in-Excel-page-breaks/m-p/47032#M5282 wkossack 2010-12-08T19:19:34Z https://communities.sas.com/t5/SAS-Enterprise-Guide/stored-Process-in-Excel-page-breaks/m-p/47033#M5283 Hi:<BR /> I do not believe that you can control the page-breaking with SAS -- once the stored process got to Excel -- every person who runs that stored process could set different page layout and printing options that would impact the place where Excel put page breaks.<BR /> <BR /> Is there anyway to make your BY groups "smaller" by adding more BY variables into the BY statement??? <BR /> <BR /> Also, this is one of those instances where it might be useful to see your stored process code and for you to explain how you populate the multiple tabs (whether the stored process does it automatically or whether you are creating new sheets by selecting "New Sheet" in the popup window for the SAS Add-in for Microsoft Office.)<BR /> <BR /> cynthia Fri, 10 Dec 2010 17:49:59 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/stored-Process-in-Excel-page-breaks/m-p/47033#M5283 Cynthia_sas 2010-12-10T17:49:59Z