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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.