topic Re: Is there a way to convert freq sgplot to % while keeping freq labels? in Graphics Programming

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

richart — Sun, 09 Feb 2020 20:42:09 GMT

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?)

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

PaigeMiller — Sun, 09 Feb 2020 20:46:48 GMT

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

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

richart — Sun, 09 Feb 2020 20:54:29 GMT

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)

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

PaigeMiller — Sun, 09 Feb 2020 21:03:31 GMT

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.

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

Rick_SAS — Mon, 10 Feb 2020 14:36:28 GMT

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;