I have a report created using Excel ODS and Proc Print. When I print the resulting Excel file, the right-most column (D) does not print with the rest of the page (but rather on a separate page). I've tried using absolute_column_width to reduce the size of column A (which is wider than all other columns) but it has no effect. I also tried fittopage='1' but that seems to apply to rows as well as columns and results in teeny-tiny unreadable print. How can I control the page width breaks? Here's my code: ODS excel FILE="&QTRLYRPT..xlsx"; ods noproctitle; ods excel options ( embedded_titles='ON' embed_titles_once='ON' EMBEDDED_FOOTNOTES='ON' EMBED_FOOTNOTES_ONCE='ON' gridlines='ON' orientation='LANDSCAPE' sheet_interval='NONE' sheet_name="Quarterly Report" row_repeat='1-8' absolute_column_width_='3,1,1,1,1,1,1' ); PROC PRINT DATA=II LABEL split='|'; ID _NAME_; VAR COL1-COL4; LABEL _NAME_='II. SELECTED EXIT CATEGORY SUMMARY |(Related Assistance Services-Only Exiters Excluded)' COL1 = 'All Career Service Exiters' COL2 = 'Classroom Training' COL3 = 'On-the-job Training' COL4 = 'Work Experience' ; format _name_ $IIROWS. ; RUN;
... View more