topic Re: i want a panel but can't use sgpanl(?) in Graphics Programming

i want a panel but can't use sgpanl(?)

pau13rown — Thu, 21 Feb 2019 21:31:11 GMT

i like this blog post by Sanjay Matange (@sanjay1 ?) https://blogs.sas.com/content/graphicallyspeaking/2014/01/18/two-in-one-graph/#prettyPhoto

but how can i create a grid of such plots e.g. if i want a grid with 4 cells and each cell contains the kind of plot Sanjay has produced. Proc sgpanel does not allow the yaxis2 which achieves Sanjay's plot, and sgplot does not allow a panel. Thus, how to achieve both features...? cheers

Re: i want a panel but can't use sgpanl(?)

Reeza — Thu, 21 Feb 2019 22:31:27 GMT

Can you drop down to GTL?

Re: i want a panel but can't use sgpanl(?)

pau13rown — Mon, 11 Mar 2019 23:33:50 GMT

i'm trying to read up on gtl, given your suggestion, but the info out there seems scattered and incomplete. Eg, i generated my figure using sgplot. How do i now gain access to the proc template code which needs to be modified and is apparently hiding in the background somewhere? I ought to use that code as a starting point, if it's at all possible to create the fig as i want it. There are papers like this: http://support.sas.com/rnd/app/ODSGraphics/papers/modtmplt.pdf which imply that it's rather easy to obtain the source code, but what they suggest amounts to nothing.... cheers

Re: i want a panel but can't use sgpanl(?)

Rick_SAS — Wed, 13 Mar 2019 12:40:19 GMT

You can use the ODS LAYOUT GRIDDED statement to assemble graphs (and/or tables) into a gridded arrangement. See

https://blogs.sas.com/content/sasdummy/2015/11/23/ods-statement-options-to-change/

and a few additional comments in

https://blogs.sas.com/content/iml/2015/12/02/matrices-graphs-gridded-layout.html

Re: i want a panel but can't use sgpanl(?)

DanH_sas — Wed, 13 Mar 2019 14:33:25 GMT

One other alternative is to use ODS LAYOUT to create your 2x2 arrangement. That way, you can still use SGPLOT four times to create each plot, but have ODS arrange them 2x2 on the page. Would that work for you?

Re: i want a panel but can't use sgpanl(?)

Reeza — Fri, 15 Mar 2019 02:04:33 GMT

@pau13rown wrote:

i'm trying to read up on gtl, given your suggestion, but the info out there seems scattered and incomplete. Eg, i generated my figure using sgplot. How do i now gain access to the proc template code which needs to be modified and is apparently hiding in the background somewhere? I ought to use that code as a starting point, if it's at all possible to create the fig as i want it. There are papers like this: http://support.sas.com/rnd/app/ODSGraphics/papers/modtmplt.pdf which imply that it's rather easy to obtain the source code, but what they suggest amounts to nothing.... cheers

Did you try the TMPLOUT out option on SGPLOT?

proc sgplot data=sashelp.cars tmplout='/folders/myfolders/demo.txt';
scatter x=mpg_highway y=mpg_city / group=origin;
run;

Generated code:

proc template;
define statgraph sgplot;
begingraph / collation=binary;
layout overlay / xaxisopts=(labelFitPolicy=Split) x2axisopts=(labelFitPolicy=Split);
   ScatterPlot X=MPG_Highway Y=MPG_City / subpixel=off primary=true Group=Origin LegendLabel="MPG (City)" NAME="SCATTER";
   DiscreteLegend "SCATTER"/ title="Origin";
endlayout;
endgraph;
end;
run;

I find the documentation pretty thorough, but you do need to use the most recent versions, SAS 9.2 is about a decade old.

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=grstatug&docsetTarget=titlepage.htm&locale=en

There's at least one or two examples on creating a lattice/panel that I see on that page.

Re: i want a panel but can't use sgpanl(?)

pau13rown — Mon, 18 Mar 2019 12:18:44 GMT

excellent answers. I'll try all 3 approaches and report back....

i decided to use the "ods layout gridded" and it worked well. My code looks like this:

ods pdf file="...\figure4.pdf"; 

title j=c h=1 "Figure 4. ...."; 
footnote ; 

ods layout gridded columns=2; 

ods region height=2.5in; 
title ; 
proc sgplot data=fig4 (where=(cohort=1)) noautolegend; 
format cohort cohort_f. ...; 
: 
run; 

ods region height=2.5in;
title ; 
proc sgplot data=fig4 (where=(cohort=2)) noautolegend; 
: 
: 
etc

and this image looks like this: figure. I guess if i played around with it more i could create a tiff file instead of pdf, and refine it in other ways

cheers