topic Re: Export Freq table and SGPLOT graph onto same PDF in SAS Programming

Export Freq table and SGPLOT graph onto same PDF

brulard — Fri, 01 Sep 2017 19:00:34 GMT

hi,

Does anyone know if it is possible to export a frequency table, and histogram onto a same PDF page?

Here is the code I use to produce distinct pdf files.

Thanks in advance,

ds pdf file="&drop.&title._&dtfrom._to_&dtto..PDF";
ods pdf StartPage=Never; 
ods noproctitle; 
TITLE1 "Ratio of Voluntary Account Closures";
proc FREQ data=a_pdf ;
TABLES Voluntary_Closure_Reason /norow nocol ; 
RUN; 
ods pdf close; TITLE1 ; 

ods pdf file='file.pdf';
PROC SGPLOT DATA=b;
VBAR Voluntary_Closure_Reason /
RESPONSE = COUNT;
TITLE 'Status Additions';
RUN; 
ods pdf close;

Re: Export Freq table and SGPLOT graph onto same PDF

WarrenKuhfeld — Fri, 01 Sep 2017 19:51:28 GMT

http://blogs.sas.com/content/graphicallyspeaking/2017/08/14/advanced-ods-controlling-precisely-output-displayed/

Use the ODS LAYOUT.

Re: Export Freq table and SGPLOT graph onto same PDF

ballardw — Fri, 01 Sep 2017 20:03:04 GMT

A lot of things will go into the determination of pagination besides the startpage option. If the table is long then there may not be any room for the graph. Or the size options for you graph may want more space and not fit with a small table.

This works for me as an example:

ods pdf file="d:\test.PDF" style=meadow;
ods pdf StartPage=Never; 
ods noproctitle; 

TITLE1 "Ratio of Voluntary Account Closures";
proc FREQ data=sashelp.class (obs=5) ;
   TABLES name /norow nocol ; 
RUN;
 
PROC SGPLOT DATA=sashelp.class (obs=5);
   VBAR name /
   RESPONSE = Height;
   TITLE 'Status Additions';
RUN; title;
ods pdf close;

Note that if you ever close the PDF with the ODS PDF Close anything that follows will likely not be in the same document much less page.

I used style meadow as it uses a smaller font than the default PDF wants and makes the table smaller.

Re: Export Freq table and SGPLOT graph onto same PDF

brulard — Thu, 07 Sep 2017 14:03:50 GMT

Appreciate the explanation.