topic Adding labels to countlabel option in sgplot vbar in SAS Programming

Adding labels to countlabel option in sgplot vbar

Abishekaa — Thu, 01 Jul 2021 19:40:09 GMT

proc sgplot data=Freq2Out;
  vbar ergRod/response=percent group=cyanToRed5dBGreater fillpattern nofill Groupdisplay=cluster datalabel=Count datalabelattrs=(size=12) name="ERG";
  format ergRod ergRod.;
  yaxis label = 'Percent of Participants (%)' labelattrs=(size=13) valueattrs=(size=13);
  xaxis label = 'Presence of Rod ERG' discreteorder=data labelattrs=(size=13) valueattrs=(size=13);
  keylegend "ERG"/ valueattrs=(Size=13)sortorder=ascending title="DAVF" titleattrs=(size=13) autoitemsize; 
run;

The "datalabel=Count" statement puts the counts of each bar at the top of the plot (Eg: 10, 20). I could like to add a label "n=", so that it shows as "n=10", "n=20" etc at the top of each bar. Is there any options in SAS to do this?

Thanks so much!

Re: Adding labels to countlabel option in sgplot vbar

tarheel13 — Thu, 01 Jul 2021 21:48:40 GMT

@Rick_SAS is there a way?

Re: Adding labels to countlabel option in sgplot vbar

Rick_SAS — Fri, 02 Jul 2021 09:44:43 GMT

I would use the XAXISTABLE statement to put the summary statistics under the bars. See

https://blogs.sas.com/content/graphicallyspeaking/2013/12/16/grouped-bar-chart-with-statisticstable/

Re: Adding labels to countlabel option in sgplot vbar

Abishekaa — Fri, 02 Jul 2021 10:03:50 GMT

Thank you, Rick 🙂