🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Lapis Lazuli | Level 10

## SGPLOT vbar with upper error bar as 3rd quartile

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;

1 ACCEPTED SOLUTION

Accepted Solutions
Meteorite | Level 14

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

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.

2 REPLIES 2
Meteorite | Level 14

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

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.

Super User

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

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;
```
Discussion stats
• 2 replies
• 2050 views
• 0 likes
• 3 in conversation