09-16-2014 03:55 PM
I met a weird problem. I output PROC REPORT into PDF file. 1-845 pages, everything looks great, however, starting from 846page, the table size (or paper size?) suddenly changed and each line was just truncated.... I pasted page 845 and 846 as below. Do you guys know what is the reason? By the way, I am using the default orientation=portrait.
09-16-2014 07:02 PM
I've seen similar behavior in other programs when a variable's print space changed just a small amount because it had more "wide" values such as "w" compared with "i" or 0 with 1. That caused a word wrap to create enough space for the offending variable.
I'd be tempted to reduce the format of the mean column to maybe four decimals but that's just a guess.
09-17-2014 06:39 PM
Thanks. May be it is a good try. However, I guess in my case, the problem column is the var format....If you compare both page, you would find, in the second page, the width of var format suddenly got wider....And I do not know why that happened...
09-17-2014 12:38 AM
Is it possible you requested the NOZERO option and SAS has just removed the columns that did not have any data for that page?
suppresses the display of the report item if its values are all zero or missing.
|Interactions||Even though the columns that you define with NOZERO do not appear in the report, you must count them when you are referencing columns by number. (See Four Ways to Reference Report Items in a Compute Block.)|
|SHOWALL in the PROC REPORT statement or in the ROPTIONS window overrides all occurrences of NOZERO.|
09-17-2014 03:33 AM
I had once similar behavior and the solution was printing with a uniform option. That was before ODS exist and a very long time ago.
SAS(R) 9.4 Output Delivery System: User's Guide, Third Edition But is see a uniform option for the PDF output for tables.
Did you use that? Take care on the notice of memory usage.
09-17-2014 07:44 AM
This seems very odd behavior -- you had 1 PROC REPORT (not 2), right? If you didn't do anything that would change options in midstream, like call a second PROC REPORT step, then this seems like something that Tech Support would want to look at and possibly refer to the developers. I'd recommend opening a track.
09-17-2014 06:46 PM
I do have two PROC REPORT. But those two are triggered based on IF condition...Only one of them could be triggered at once, not both of them. So, I may have to contact with Tech Support. Thanks!
09-17-2014 06:55 PM
Thanks! This option can help solve this problem. But, I still can see the size of table has changed from the page 845 to the page 846...I guess it is due to the SAS tech issue. Thanks anyway!
09-18-2014 12:49 AM
Yep the format was the other trigger for that changeable not stable layout.
That is where the uniform option did help.
09-18-2014 11:08 AM
It is very weird....Uniform option worked yesterday but it does not work today when I rerun the code....Too weird....I have to change the orientation to landscape....sign~