Is there a way to convert freq sgplot to % while keeping freq labels?

[richart]

I have something like attached. Is there a way to change the y axis to % while keeping the annotated actual count above the bars? (i.e. change response to pct but the 56.5, 62.8 etc above the bars?)

[PaigeMiller]

Percent of what? I don't understand how this applies to heights.

[richart]

crude example, shouldn't have used heights... just used it as the visualization. pretend it is count data. Want % each bar contributes to the total count (if the heights were counts)

[PaigeMiller]

Okay, if I am understanding the question properly (and I may not be), you can use the VBAR statement in PROC SGPLOT, with the DATALABEL= option and probably other options to achieve this. The formatting of the y-axis can be achieved by the YAXIS command with the VALUESFORMAT= option.

[Rick_SAS]

I think you need to pre-summarize the data so that the input data contains a Count for each category. Then you can use STAT=PCT to set the Y axis and use DATALABEL=Count to specify the bar labels:

/* create bar chart of counts by age */
proc means data=sashelp.class;
class age;
var height;
output out=ClassSummary N=Count;
run;

proc sgplot data=ClassSummary;
vbar age / freq=Count stat=pct datalabel=Count;
run;