topic Re: Remove whitespace in ODS PDF in ODS and Base Reporting

Remove whitespace in ODS PDF

Kastchei — Thu, 18 Oct 2018 19:07:45 GMT

Hello,

I am creating a PDF out of proc compare. The output has an extreme amount of whitespace, such that a completely clean compare takes up an entire page. This doesn't happen in the HTML output or listing output. It almost looks as if the entire thing has been double-spaced. Any ideas how to get rid of this? Screenshots are attached.

Warm regards,

Michael

Re: Remove whitespace in ODS PDF

Reeza — Thu, 18 Oct 2018 19:40:04 GMT

Show some code please that generates that output.

@Kastchei wrote:

Hello,

I am creating a PDF out of proc compare. The output has an extreme amount of whitespace, such that a completely clean compare takes up an entire page. This doesn't happen in the HTML output or listing output. It almost looks as if the entire thing has been double-spaced. Any ideas how to get rid of this? Screenshots are attached.

Warm regards,

Michael

Re: Remove whitespace in ODS PDF

Cynthia_sas — Thu, 18 Oct 2018 19:40:38 GMT

Hi:
In my memory of some SAS output, PROC COMPARE doesn't work the way other ODS output works. The entire report from PROC COMPARE is put inside a "box" or container and then all the output is written out as it would have been written out in the "old days" before ODS -- as thought it were going to the old OUTPUT Window.

I do not believe there's a way to change the output from PROC COMPARE.

In the old days, I used to write PROC COMPARE to a .LST file or .TXT file using PROC PRINTTO and then open the .LST file with Word and "pretty it up". The type of output that is created is called "Batch output" from PROC COMPARE.

This document https://support.sas.com/rnd/base/ods/templateFAQ/ODS91.pdf has PROC TEMPLATE code for changing the font from SAS Monospace to a different font, but does not address the spacing issue or whitespace issue. You might want to check with Tech Support about whether there's a way to influence the spacing (but my guess is that there's not).

Cynthia

Re: Remove whitespace in ODS PDF

Reeza — Thu, 18 Oct 2018 19:43:46 GMT

Change your style to journal or minimal and set startpage to never.

data cars;
set sashelp.cars;
call streaminit(25);
if age in (13, 14) then call missing(weight);
if age in (10, 12) then height = height + rand('normal', 5);
run;


ods pdf file='C:\_localdata\demo.pdf' style=minimal startpage=never;
proc compare data=cars compare=sashelp.cars;
run;
ods pdf close;

@Reeza wrote:

Show some code please that generates that output.

@Kastchei wrote:

Hello,

I am creating a PDF out of proc compare. The output has an extreme amount of whitespace, such that a completely clean compare takes up an entire page. This doesn't happen in the HTML output or listing output. It almost looks as if the entire thing has been double-spaced. Any ideas how to get rid of this? Screenshots are attached.

Warm regards,

Michael