topic Re: how to seperate the two plots in proc sgplot with y2a? Can option= y2axis be used in proc templa in Graphics Programming

how to seperate the two plots in proc sgplot with y2a? Can option= y2axis be used in proc template?

blueskyxyz — Thu, 12 Mar 2020 05:23:55 GMT

proc sgplot data=final;
   /*discreteoffset to seperate the two box plot*/
   /* the same offsets must be used in both YAXIS and Y2AXIS stmts */
   scatter x=AVISITN y=mean  /  discreteoffset=0.5  YErrorUpper=uclm YErrorLower=lclm ;
   series  x=AVISITN y=mean / ;

   scatter x=AVISITN y=mean1  /Y2Axis discreteoffset=-0.5  YErrorUpper=uclm1 YErrorLower=lclm1;
   series  x=AVISITN y=mean1/ Y2Axis;

   /*reference line*/
   refline 0  / axis=y;

   /*grid : line */
   yaxis   label="A (unit1)" offsetmax=0.1  offsetmax=0.1 values=(-2 to 0 by 0.2);
   y2axis  label="A (unit2)" offsetmax=0.1 offsetmax=0.1 values=(-1.0 to 0 by 0.1);
run;

have :

dataset:

Analysis	_TYPE_	_FREQ_	lclm	uclm	mean	lclm1	uclm1	mean1
Visit
(N)
2	1	38	-0.55065	-0.31251	-0.43158	-0.1778	-0.10091	-0.13936
3	1	40	-0.63928	-0.36022	-0.49975	-0.20642	-0.11631	-0.16137
4	1	145	-0.55832	-0.3985	-0.47841	-0.18028	-0.12868	-0.15448
5	1	35	-0.84917	-0.48169	-0.66543	-0.2742	-0.15554	-0.21487
6	1	108	-0.66893	-0.47219	-0.57056	-0.216	-0.15247	-0.18423
7	1	71	-0.65607	-0.37041	-0.51324	-0.21185	-0.1196	-0.16573

want:

use different axis for different units:

data want;
set have;
avisitn1=avisitn+0.1;
run;

Re: how to seperate the two plots in proc sgplot with y2a? Can option= y2axis be used in proc templa

DanH_sas — Thu, 12 Mar 2020 05:18:12 GMT

The key here is that the X axis variable you have is not discrete. Therefore, the DISCRETEOFFSET option is ignored. In this case, you need to explicitly tell the XAXIS to be discrete. Add the following line and your code should work as expected:

XAXIS type=discrete;

Hope this helps!
Dan

Re: how to seperate the two plots in proc sgplot with y2a? Can option= y2axis be used in proc templa

blueskyxyz — Thu, 12 Mar 2020 08:16:41 GMT

hi, Dan, thanks. It works, but the graph is not imcomplete.

avisitn=avisitn+0.1 , which also works.

Re: how to seperate the two plots in proc sgplot with y2a? Can option= y2axis be used in proc templa

Quentin — Thu, 12 Mar 2020 14:24:54 GMT

I'm not sure I'm understanding what your looking for, but I just posted a question using offsetmin and offsetmax that shows how to completely separate the y2axis. So the bottom of half of the plot shows data plotted against yaxis, and the top half shows data plotted against y2axis:

https://communities.sas.com/t5/Graphics-Programming/SGplot-with-3-y-axes/m-p/631567#M19592

(My question there is whether SGPLOT can do this with 3 y axes...)

Re: how to seperate the two plots in proc sgplot with y2a? Can option= y2axis be used in proc templa

DanH_sas — Thu, 12 Mar 2020 14:28:35 GMT

On the XAXIS statement add offsets to both ends:

XAXIS offsetmix=0.1 offsetmax=0.1;

That should be enough; bit if not, you can increase it.

Re: how to seperate the two plots in proc sgplot with y2? Can y2axis be used in proc template?

blueskyxyz — Fri, 13 Mar 2020 02:22:35 GMT

https://support.sas.com/documentation/cdl/en/grstatgraph/63878/HTML/default/viewer.htm#n1tf9vsmrjtmvin1x3aeo74h9ct8.htm

Dan, I appreciate your help, my figure looks good now.

Another question, Can y2axis be used in proc template?

Re: how to seperate the two plots in proc sgplot with y2a? Can option= y2axis be used in proc templa

blueskyxyz — Fri, 13 Mar 2020 02:25:27 GMT

Hi Quentin , my question has been solved,thanks.

I don't want show my figure with panelby.

Re: how to seperate the two plots in proc sgplot with y2? Can y2axis be used in proc template?

DanH_sas — Fri, 13 Mar 2020 04:19:59 GMT

Yes, use the YAXIS=Y2 option on your SERIESPLOT.

Re: how to seperate the two plots in proc sgplot with y2? Can y2axis be used in proc template?

blueskyxyz — Tue, 17 Mar 2020 08:48:56 GMT

Thanks again, Dan, I will try to use proc template for this figure