topic Re: Why the paper size suddenly changed in a PDF output in ODS and Base Reporting

Why the paper size suddenly changed in a PDF output

Tiny_Kane — Tue, 16 Sep 2014 19:55:35 GMT

Hello~

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.

Re: Why the paper size suddenly changed in a PDF output

ballardw — Tue, 16 Sep 2014 23:02:15 GMT

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.

Re: Why the paper size suddenly changed in a PDF output

Tom — Wed, 17 Sep 2014 04:38:23 GMT

Is it possible you requested the NOZERO option and SAS has just removed the columns that did not have any data for that page?

NOZERO

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.

Re: Why the paper size suddenly changed in a PDF output

jakarman — Wed, 17 Sep 2014 07:33:10 GMT

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.

Re: Why the paper size suddenly changed in a PDF output

Cynthia_sas — Wed, 17 Sep 2014 11:44:30 GMT

Hi:

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.

cynthia

Re: Why the paper size suddenly changed in a PDF output

Tiny_Kane — Wed, 17 Sep 2014 22:39:42 GMT

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...

Re: Why the paper size suddenly changed in a PDF output

Tiny_Kane — Wed, 17 Sep 2014 22:41:40 GMT

Hm.... I checked...I did not add any NOZERO option there....

Re: Why the paper size suddenly changed in a PDF output

Tiny_Kane — Wed, 17 Sep 2014 22:46:08 GMT

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!

Re: Why the paper size suddenly changed in a PDF output

Tiny_Kane — Wed, 17 Sep 2014 22:55:31 GMT

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!

Re: Why the paper size suddenly changed in a PDF output

jakarman — Thu, 18 Sep 2014 04:49:40 GMT

Yep the format was the other trigger for that changeable not stable layout.

That is where the uniform option did help.

Re: Why the paper size suddenly changed in a PDF output

Tiny_Kane — Thu, 18 Sep 2014 15:08:25 GMT

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~