topic SGPLOT vbar with upper error bar as 3rd quartile in Graphics Programming

SGPLOT vbar with upper error bar as 3rd quartile

Melk — Tue, 31 Jul 2018 19:11:44 GMT

I am running a vertical bar chart for stat=median and would like an upper error bar to represent the 3rd quartile of the IQR. Is there a way to do this? I think error bars are only displayed when stat = mean?

proc sgplot data=dat;
vbar x/ response=y stat=median;
run;

Re: SGPLOT vbar with upper error bar as 3rd quartile

Jay54 — Tue, 31 Jul 2018 19:37:50 GMT

For such custom situations, you will need to compute the median and 3rd quartile values by category using PROC MEANS. Then you can use vbarparm to plot the bar chart of median by category and overlay a scatter of median by category with upper x-error bar to display the quartile. You can set the scatter marker size to zero.

Re: SGPLOT vbar with upper error bar as 3rd quartile

ballardw — Tue, 31 Jul 2018 21:34:48 GMT

Or using more of a "draw" it approach using NEEDLE statement with pre-summarized data:

proc summary data=sashelp.class nway;
   class sex;
   var weight;
   output out=plot (drop=_:) median= Q3= /autoname;
run;

   
proc sgplot data=plot;
  needle x=sex y=weight_q3 /markers markerattrs=(symbol=tack);
  vbarparm category=sex response=weight_median/ name='bar';
  keylegend 'bar';
run;