topic Re: How to generate a serial of graphs by SGPLOT as we use BY statement in PROC GPLOT and GREPLAY in Graphics Programming

How to generate a serial of graphs by SGPLOT as we use BY statement in PROC GPLOT and GREPLAY

MINX — Mon, 11 Sep 2017 17:17:54 GMT

Does anyone have a good idea to use SGPLOT to generate a serial of graphs (two graphs per page) and re-order the display sequence? For example, graph 1 and 5 for the 1st page, 2 and 6 for 2nd page, etc. I always have to make a macro loop to do that for SGPLOT. It used to be done by PLOT + GREPLAY. I hope there is any simple solution. Thank you

Re: How to generate a serial of graphs by SGPLOT as we use BY statement in PROC GPLOT

DanH_sas — Mon, 11 Sep 2017 16:48:59 GMT

The BY statement works with SGPLOT as is does with GPLOT. What issues have you found with it?

Re: How to generate a serial of graphs by SGPLOT as we use BY statement in PROC GPLOT

ballardw — Mon, 11 Sep 2017 17:12:08 GMT

proc sort data=sashelp.class out=classsort;
  by sex;
run;

proc sgplot data=classsort;
   by sex;
   scatter x=height y=weight;
run;

Should create one graph per page in ODS destinations such as ODS RTF, PDF or one per worksheet in Excel or tagsets.excelxp.

Re: How to generate a serial of graphs by SGPLOT as we use BY statement in PROC GPLOT

MINX — Mon, 11 Sep 2017 17:19:47 GMT

Thank you for your quick response. I update my post to clarify my question. Basically it there any simple way as GREPLAY to re-order the display in SGPLOT?

Thank you

Re: How to generate a serial of graphs by SGPLOT as we use BY statement in PROC GPLOT

DanH_sas — Mon, 11 Sep 2017 17:34:43 GMT

You can use ODS DOCUMENT to do that. The example below replays everything in the reverse order in which it was created, but you can get the proc to replay any of the pieces in any order you want. Use the LIST command in the proc to get the paths to replay.

Hope this helps!

Dan

ods _all_ close;
ods document name=scat;
proc sort data=sashelp.class out=class; by sex; run;
proc sgplot data=class;
by sex;
scatter x=weight y=height;
run;
ods _all_ close;

ods html;
proc document name=scat;
replay SGPlot#1\BYGroup2#1\SGPlot#1;
replay SGPlot#1\BYGroup1#1\SGPlot#1;
run;
quit;

Re: How to generate a serial of graphs by SGPLOT as we use BY statement in PROC GPLOT

MINX — Mon, 11 Sep 2017 17:58:54 GMT

Thank you. combination of ODS document and proc document work.

Re: How to generate a serial of graphs by SGPLOT as we use BY statement in PROC GPLOT and GREPLAY

Rick_SAS — Wed, 13 Sep 2017 12:49:24 GMT

For a general overview of using PROC DOCUMENT to reorder the output, see "Reorder the output from a BY-group analysis in SAS," which contains many links for further reading.

Re: How to generate a serial of graphs by SGPLOT as we use BY statement in PROC GPLOT and GREPLAY

Doug____ — Thu, 25 Oct 2018 15:16:43 GMT

Can this method also work for generating multiple plots per page (say in a 2x2 layout)?

Re: How to generate a serial of graphs by SGPLOT as we use BY statement in PROC GPLOT and GREPLAY

Rick_SAS — Thu, 25 Oct 2018 15:39:39 GMT

For most applications, if you want a panel that shows multiple graphs, you can use PROC SGPANEL. There are examples in the doc. For a 2-D lattice example, see this blog post, which shows how to use the PANELBY statement:

proc sgpanel data=Have;
   panelby ID /  rows=2 columns=2 onepanel;
   /* graph statements go here */
run;