I'm trying to figure out why the formatting of my reports suddenly changed.
I had been exporting a report with 8 columns, all which fit on a single page in a word document. This month, it decided to put a page break in the middle (so the first 4 columns are on the first page, the second 4 columns are on the second page). Code didn't change at all.
So, thoughts:
- data in the columns got bigger, so the width is no longer able to fit on one page. I thought the ods options "keepn" or "trkeep" would solve these problems, but neither made any difference.
- some other sas setting made the column width defaults change. So I put "width=10" on the define statements within the proc report. Again, nothing changed.
My Code:
ODS RTF FILE="&REPORT_LOC./&outfile..rtf" keepn trkeep;
proc report data=FinalRpt2 nowindows headline headskip spacing=2 missing split='*';
column storeNum dept sales;
define storeNum / order width=10 'Store Number';
define dept / order width=10 'Department';
define sales / display width=10 'Sales';
run;