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

[LGoldman]

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

[Cynthia_sas]

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