I am trying to make a group of proc report tables completely formatted using ODS Excel, rather than writing Excel Macros to edit the formats to make the tables printable. For the majority of my tables using the option "fittopage" works since they are one page tables. However I have two tables that span multiple pages in length and cannot figure out how to get the 13 columns to fit (in an Excel macro I can set the output to "fit all columns on page") then set where the page breaks need to happen. Is there a way to do this in ODS Excel?
... View more