Trying to create prevalence chart with error bars and percentages

Question

I am trying to create a bar graph that has error bars showing the upper and lower confidence limits. However all my code will not produce the desired error bars. I would also like to include the prevalence percentages in the graph.

This is the code I have that inputs the data

data disabilities;
input disability $ prevalence lower upper;
datalines;
Physical 86.38 84.75 88.01
Cognitive 83.42 81.99 84.85
Both 80.71 78.23 83.19
No 88.26 87.76 88.76;
run;

I then run the following code to produce a bar graph

proc sgplot data=disabilities;  
vbarparm category=disability response=prevalence / group=disability fillpattern;  
band x=disability lower=lower upper=upper / group=disability transparency=0.5; 
xaxis discreteorder=datapart;
run;

I am trying to achieve something similar to this:

Any help is appreciated!!

Check out this example: https://support.sas.com/kb/42/542.html — Stu Sztukowski, Apr 12 '23 at 19:45

score 1 · Accepted Answer · answered Apr 12 '23 at 20:42

You can label the bars with the datalabel option, and add limits with limitupper / limitlower. Unfortunately when you use both it labels the bars and the limits, and puts the values below the bars, in a table.

proc sgplot data=disabilities;  
vbarparm category=disability response=prevalence
  / group=disability groupdisplay=cluster fillpattern 
    datalabel limitlower=Lower limitupper=Upper datalabelpos=data
;  
xaxis discreteorder=data;
run;

For a plot closer to what you want, you might be able to get it from SGPLOT overlaying multiple plots (one for the bars, another for the error bars). Or with GTL.

Personally, I'm not a fan of labeling values in a bar chart (or most charts). It's a chart, not a table. And in the example you showed, the labels have the value of the bar, but they're positioned at the top of the error bar, which is confusing.

score 0 · Answer 2 · answered Jul 03 '23 at 16:57

Be aware of potential conflict when label overlay plots. Please try following codes:

data disab;
    length label $8;
    set disabilities;
    label = strip(prevalence)||"%" ;
run;


ods _all_ close;
ods graphics on/reset;
ods rtf;

proc sgplot data=disab;  
    vbarparm category =disability  response=prevalence 
        /group=disability fillpattern GROUPDISPLAY=CLUSTER  
    ;        
    Highlow  High = upper low = lower x = disability/   
        highcap =serif lowcap = serif lineattrs = 
        Grapherror 
        highlabel= label;
    yaxis offsetmin = 0.05 offsetmax = 0.05  ;
ods _all_ close;
ods listing;

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). — Community, Jul 06 '23 at 16:14

Trying to create prevalence chart with error bars and percentages

2 Answers2