How to Preserve ODS Gridded Layout when using Proc Document

P_S_ — Fri, 13 Feb 2015 21:14:50 GMT

Hi All,

This is my first attempt to use Proc Document while still preserving the ODS Layout in my PDF Output Destination.

I am using SAS 9.3. For this example I am using sashelp.stocks dataset.

Here is what I am trying to achieve:

I want 3 plots in each page.

1st page will have 1 column and 3 plots.

2nd page has 2 columns: Column 1 has 2 plots & Column 2 has 1 plot.

I was able to achieve it with the code below using ODS Gridded Layout but I want to preserve this layout when I use PROC DOCUMENT Later on.

/*This codes gives me the layout I want*/
%macro plot_stocktrend(company);

ods graphics on /height=4in width=5in border=on;

proc sgplot data=sashelp.stocks(where=(date >= "01jan2000"d and stock = "&company.")) description= "Stock Trend : &company";;

title "Stock Trend : &company";

series x=date y=close;

series x=date y=low;

series x=date y=high;

run;

title;

%mend plot_stocktrend;

%macro plot_volume(company);

proc sgplot data=sashelp.stocks (where=(date >= "01jan2000"d

and date <= "01jan2001"d

and stock = "&company.")) description= "Stock Volume : &company";;

title "Stock Volume vs. Close : &company.";

vbar date /response=volume;

vline date /response=close y2axis;

run;

title;

%mend plot_volume;

title;

goptions reset=goptions device=sasprtc target=sasprtc ftext='Arial' ftitle='Arial/bold' ;

options orientation = portrait papersize = letter nodate nonumber;

ods _all_ close;

ods noproctitle;

ods pdf file ="~/gridded_layout.pdf" pdftoc=1 startpage=never;

ods layout gridded columns=1 rows=3 row_heights = (3in 3in 3in ) row_gutter=.5in;

ods region height = 3in ;

%plot_stocktrend(IBM);

ods region height = 3in;

%plot_stocktrend(Intel);

ods region height = 3in;

%plot_stocktrend(Microsoft);

ods layout end;

ods pdf startpage=now;

ods layout gridded columns=2 rows=3 row_heights = (3in 3in 3in ) row_gutter=.5in;

ods region height = 3in ;

%plot_volume(IBM);

ods region height = 3in;

%plot_volume(Intel);

ods region height = 3in;

%plot_volume(Microsoft);

ods layout end;

ods pdf close;

OUTPUT:


PAGE 1

This example has just 6 plots arranged in 2 pages. But in reality I have over 150 plots that I need to output to PDF.
Thus in my PDF, I also need a good bookmark so that it will be easy to navigate the plots.

To achieve that I want to use ODS Document Destination and Proc Document. But at the same time I want to preserve my original layout that I have shown above.

I have used the code below. This creates a good navigation panel. But the layout is not preserved. It outputs one plot in each page. I need to modify this code so that I can somehow use my ODS Gridded Layout statement.

If there is any other techniques to achieve this, I would be happy to use that as well.

Please advise.

ods document name=mydocument(write);

%plot_stocktrend(IBM);

%plot_stocktrend(Intel);

%plot_stocktrend(Microsoft);

%plot_volume(IBM);

%plot_volume(Intel);

%plot_volume(Microsoft);

ods document close;

proc document name=mydocument;

list / levels=all;

run;

proc document name=mydocument;

make trend,volume;

setlabel \trend#1 "Stock Trend";

setlabel \volume#1 "Stock Volume";

copy \Sgplot#1\SGPlot#1 to \trend#1;

copy \Sgplot#2\SGPlot#1 to \trend#1;

copy \Sgplot#3\SGPlot#1 to \trend#1;

copy \Sgplot#4\SGPlot#1 to \volume#1;

copy \Sgplot#5\SGPlot#1 to \volume#1;

copy \Sgplot#6\SGPlot#1 to \volume#1;

run;

quit;

title;

goptions reset=goptions device=sasprtc target=sasprtc ftext='Arial' ftitle='Arial/bold' ;

options orientation = portrait papersize = letter nodate nonumber;

ods _all_ close;

ods noproctitle;

ods pdf file ="~/gridded_layout_w_doc.pdf" pdftoc=1;

proc document name=mydocument;

replay \trend#1;

replay \volume#1;

run;

quit;

ods pdf close;

RESULTS:

Navigation Panel is exactly what I need.
But plots are one per page.

Re: How to Preserve ODS Gridded Layout when using Proc Document

ballardw — Fri, 13 Feb 2015 23:42:10 GMT

I think you can use the ODS PDF Bookmarkgen=ON ; ODS PDF Bookmarkgen=OFF; to toggle at selected points in you code whether to create a bookmark or not.

topic Re: How to Preserve ODS Gridded Layout when using Proc Document in ODS and Base Reporting

How to Preserve ODS Gridded Layout when using Proc Document

Re: How to Preserve ODS Gridded Layout when using Proc Document