Is there an alternative to Proc Report panels feature with ODS PDF

LGoldman — Thu, 22 Mar 2012 20:19:28 GMT

I'm still using SAS 9.1.3. 

I have the output of several proc reports writing to a single PDF in landscape mode. The output of one of the reports is rather thin and could be written to the landscape page with 2 panels to save paper. But since I'm using the ODS PDF destination, the panels feature is not available.

Is there an alternative technique, style or other that I may employ? If there is, will it work if I'm using a BY statement in the PROC Report?

Thank you,

Lori

Re: Is there an alternative to Proc Report panels feature with ODS PDF

Cynthia_sas — Thu, 22 Mar 2012 21:25:09 GMT

Hi:

The COLUMNS= option works with ODS PDF and ODS RTF to produce something similar to what PANELS did (does) in the LISTING destination.

http://support.sas.com/kb/5/810.html (the option has been around for a while)

COLUMNS= may not deal with BY group processing out of the box -- since it is happening at a higher level (the ODS invocation) and the BY is happening down inside the procedure. You might need to have a separate PROC REPORT step for each BY GROUP with an explicit STARTPAGE between each step. Something like this:

ods pdf file='xxx.pdf' COLUMNS=3;

** proc report for by group 1;

ods pdf startpage=now columns=3;

** proc report for by group 2;

ods pdf startpage=now columns=3;

** proc report for by group 3;

ods pdf close;

cynthia

topic Re: Is there an alternative to Proc Report panels feature with ODS PDF in ODS and Base Reporting

Is there an alternative to Proc Report panels feature with ODS PDF

Re: Is there an alternative to Proc Report panels feature with ODS PDF