topic Re: Output of PROC SGPLOT/SGPANEL with BY statement in multiple PDF pages in Graphics Programming

Output of PROC SGPLOT/SGPANEL with BY statement in multiple PDF pages

sassy7 — Thu, 01 Dec 2022 11:08:48 GMT

Hello experts,

I would like to save the output of a PROC SGPLOT/SGPANEL with a BY statement on multiple pdf pages.

At present there are about 8 different categories - values of the by variable - that I would like to represent with a graph, hence using the BY statement is the easiest thing.

Problem is, the pdf output stops after the first graph, namely the first value of the by variable.

I browsed a bit on communities.sas.com and saw several papers/answers about multiple graphs in a PDF page (meaning one PDF page) but my case is the opposite.

As PDF output, I would like to obtain multiple PDF pages, generated by proc sgplot/proc sgpanel with a BY statement.

How to save all the graphs in PDF?

Kind regards

Re: Output of PROC SGPLOT/SGPANEL with BY statement in multiple PDF pages

svh — Thu, 01 Dec 2022 14:06:27 GMT

Have you sorted the input data set by the BY variable? When you use the BY statement in a SAS procedure, it needs to be sorted by that variable.

Re: Output of PROC SGPLOT/SGPANEL with BY statement in multiple PDF pages

sassy7 — Thu, 01 Dec 2022 15:19:50 GMT

Of course it's sorted 😉

Re: Output of PROC SGPLOT/SGPANEL with BY statement in multiple PDF pages

DanH_sas — Thu, 01 Dec 2022 15:21:57 GMT

Are you using ODS LAYOUT in your code?

Re: Output of PROC SGPLOT/SGPANEL with BY statement in multiple PDF pages

sassy7 — Mon, 05 Dec 2022 14:58:29 GMT

Yes, it's used, but as a PDF only the first page (pdf) is visible

Re: Output of PROC SGPLOT/SGPANEL with BY statement in multiple PDF pages

DanH_sas — Mon, 05 Dec 2022 15:36:06 GMT

Do you have the ADVANCE=BYGROUP option on your ODS LAYOUT GRIDDED statement?

Re: Output of PROC SGPLOT/SGPANEL with BY statement in multiple PDF pages

ballardw — Mon, 05 Dec 2022 16:28:36 GMT

@sassy7 wrote:
Yes, it's used, but as a PDF only the first page (pdf) is visible

Another example of where you really need to provide the entire code as interactions between all the options between procedure and ods destination options need to be known to address such.

Re: Output of PROC SGPLOT/SGPANEL with BY statement in multiple PDF pages

sassy7 — Tue, 06 Dec 2022 11:01:06 GMT

Hello,

I tried to use "ods layout gridded advance=bygroup;" but it prints only the first page, both as SAS Results and PDF.

Here is my SAS code: with this code it's possible to get the whole output in SAS results, but only the first page as PDF.

the variable KIND contains 8 unique values, hence the graph is grouped by KIND variable.

ODS layout start;

proc sgpanel data=work.ds_sas dattrmap=attrmap;
panelby kind/ novarname spacing=5 columns=1 ;
vbar YEAR / response=Percent group=category groupdisplay=stack attrid=myid;
rowaxis grid values=(0 to 100 by 10) label="Percentage";
colaxistable nhouse / class=category stat=sum title="house num.";
label category="Category"
kind="Kind";
run;

ods layout end;

Re: Output of PROC SGPLOT/SGPANEL with BY statement in multiple PDF pages

DanH_sas — Tue, 06 Dec 2022 19:29:31 GMT

Okay, instead of using ODS LAYOUT and ADVANCE=BYGROUP, remove the layout code and use STARTPAGE=BYGROUP on the ODS PDF statement. That should get you what you want.

Hope this helps!
Dan