topic Re: Change percent to freq in sgplot/hbar in Statistical Procedures

Change percent to freq in sgplot/hbar

FloB — Wed, 24 Feb 2021 11:07:18 GMT

Dear all,

I am trying to get a hbar graph using sgplot to represent the relative contribution of scores (0 to 3) in 2 groups.

I used the following code:

data tempo;
input codetrt score nbpat;
allpat=1;
cards;
1 0 12
1 1 8
1 2 5
1 3 8
2 0 5
2 1 6
2 2 9
2 3 15
run;

proc sgplot data=tempo pctlevel=group ;
hbar codetrt / response=allpat group=score stat=percent seglabel freq=nbpat;
run;

I would like to get the frequency counts instead of percentages inside each segment.

Could anyone help?

Thanks

Re: Change percent to freq in sgplot/hbar

PeterClemmensen — Wed, 24 Feb 2021 11:17:45 GMT

Like this?

proc sgplot data=tempo pctlevel=group ;
hbar codetrt / response=allpat group=score stat=freq seglabel freq=nbpat;
run;

Result:

Re: Change percent to freq in sgplot/hbar

FloB — Wed, 24 Feb 2021 11:27:47 GMT

Not quite...

As in the same time, I want the cumulative percent to add-up to 100% in each group, and get the cumulative percent on the x-axis.

Re: Change percent to freq in sgplot/hbar

Rick_SAS — Wed, 24 Feb 2021 11:40:23 GMT

See the article "Construct a stacked bar chart in SAS where each bar equals 100%", which includes code for PROC SGPLOT. The article does not use the SEGLEVEL option, but I think you already know how to do that.

Re: Change percent to freq in sgplot/hbar

FloB — Wed, 24 Feb 2021 11:58:45 GMT

Thank you for the reference, but I have no problem to produce a 100% stacked bar plot.

The only thing I want to change from the graph I posted is to get the freqencies instead of the percentages displayed inside the segments of the bars

Re: Change percent to freq in sgplot/hbar

ballardw — Wed, 24 Feb 2021 16:49:28 GMT

@FloB wrote:

Thank you for the reference, but I have no problem to produce a 100% stacked bar plot.

The only thing I want to change from the graph I posted is to get the freqencies instead of the percentages displayed inside the segments of the bars

I suspect you'll have to summarize the data before plotting so you have a variable containing the frequency that can be used to display with a DATALABEL=<freqvar> if you are going to plot percentages.

Going back to the days of GCHART in SAS 6 almost never used the stat= approach to create graphs because I almost always wanted/needed something that was not available. So I would summarize the data to have all the values I needed and control the plot.

Re: Change percent to freq in sgplot/hbar

FloB — Fri, 26 Feb 2021 09:31:47 GMT

Thank you all for considering my request.

I finally managed to get what I wanted with the sganno= option and the annotate facilities using a table from a previous PROC FREQ