Plot means with standard error bars from calculated data with PROC SGPLOT

[_maldini_]

I'm trying to use PROC SGPLOT to plot means w/ SE bars, per this code (Sample 42542: Plot means with standard error bars from calculated data with PROC SGPLOT).

How can I add a grouping variable so that there will be a line for each level of the group (e.g. Treatment and control)?

Thanks!

[Reeza · Accepted solution]

It sounds like you have two BY variables. So for the calculations make sure to specify the two BY variables.

For SGPLOT try the GROUP= GROUP_VAR on the scatter statement. 

Check the doc for the SCATTER statement for more details.

[Ksharp]

Use GROUP= option . Check this out.

http://blogs.sas.com/content/graphicallyspeaking/2012/03/30/cluster-groups/

data have;
infile cards expandtabs truncover;
input drug $ group$ mean lcl ucl;
cards;
A Treat   10  6 14
A Placebo  8  6 10
B Treat   20  16 24
B Placebo  12  6 14
;
run;
proc sgplot data=have;
  scatter x=drug y=mean/ yerrorlower=lcl yerrorupper=ucl group=group
          markerattrs=(symbol=circlefilled)
          groupdisplay=cluster clusterwidth=0.5 errorbarattrs=(thickness=1);
  series  x=drug y=mean/ lineattrs=(pattern=solid) group=group
          groupdisplay=cluster clusterwidth=0.5 lineattrs=(pattern=dash thickness=2)
           name='s';
  yaxis label='Mean with 95% CL' grid;
  xaxis display=(nolabel);
  keylegend 's' / title='Treatment';
  run;