topic Re: How do I get percents by group in SGPLOT? in Graphics Programming

How do I get percents by group in SGPLOT?

kpro1234 — Wed, 08 Aug 2018 19:03:06 GMT

I am using this code to get percent of bars within group (data_column_C), but what I am getting is percent within data_column_A category.

Basically I want the percents to sum up to 100% for data_column_C and have individual bar by data_column_A.

proc sgplot data=data_table pctlevel=group;
vline data_column_A /response=data_column_B stat=mean limitstat=clm markers group=data_column_C lineattrs=(thickness=2);
vbar data_column_A / response=data_column_B y2axis transparency=0.75 group=data_column_C groupdisplay=cluster stat=percent;
run;

Re: How do I get percents by group in SGPLOT?

DanH_sas — Wed, 08 Aug 2018 19:29:39 GMT

If I'm interpreting your request correctly, you really want to set PCTLEVEL=GRAPH (which is the default). Give that a try and see if the numbers are what you expect.

Thanks!

Dan

Re: How do I get percents by group in SGPLOT?

kpro1234 — Wed, 08 Aug 2018 19:33:47 GMT

I had tried that, when I do PCTLEVEL=GRAPH I get percents for the entire data.

If I do PCTLEVEL=GRAPH and then add a BY DATA_COLUMN_C statement after VBAR, then I get what I need but in two different graphs. But I am trying to have them both in one GRAPH.

Trying to get distribution of data in PERCENT but the percents should add up to 100 by the GROUP variable.

Re: How do I get percents by group in SGPLOT?

DanH_sas — Wed, 08 Aug 2018 19:38:11 GMT

Can you post a picture of what you're getting without the BY statement?

Re: How do I get percents by group in SGPLOT?

kpro1234 — Wed, 08 Aug 2018 19:47:45 GMT

What I want is that the blue bars sum up to 100% and the pink bars also sum up to 100%. The variable name differentiating them is DATA_COLUMN_C in my code above. 0-14 are DATA_COLUMN_A values and DATA_COLUMN_B is the response variable.

Re: How do I get percents by group in SGPLOT?

DanH_sas — Wed, 08 Aug 2018 19:54:16 GMT

The way you can do this is to transpose the data such that the values in DATA_COLUMN_B are put into DATA_COLUMN_B1 and DATA_COLUMN_B2, depending on the value in DATA_COLUMN_C. Then, your plot becomes 2 vbar sttements with stat=mean and 2 vline statements with stat=percent. The PCTLEVEL option will not be required.

Hope this helps!

Dan

Re: How do I get percents by group in SGPLOT?

kpro1234 — Wed, 08 Aug 2018 20:01:41 GMT

In this case I have 2 distinct values in DATA_COLUMN_C, but I more in other scenarios. So transforming and repeating should work as you suggested, but I wish there was an option that would make it happen without transforming data. From the documentation PCTLEVEL seemed like was the solution but it is giving percent by DATA_COLUMN_A grouping. Thanks for your responses, will have to do that work around if no other solution.

Re: How do I get percents by group in SGPLOT?

yin1 — Wed, 20 May 2020 17:25:23 GMT

i think this is a much needed function in sgplot.

my work-around is to use proc freq to export the percentages and then use sgplot. like

proc freq data=xxx noprint;table a*b/out=XXXX outpct;run;

proc sgplot data=XXXX;vbar b /response=pct_row group=a groupdisplay=cluster;run;

Re: How do I get percents by group in SGPLOT?

rwat1 — Fri, 10 Sep 2021 18:34:50 GMT

This exact code worked for me. Thank you.

Re: How do I get percents by group in SGPLOT?

kz_ — Thu, 28 Oct 2021 19:53:22 GMT

This is exactly what I'm trying to do! But it looks like proc sgplot doesn't offer any options.

Re: How do I get percents by group in SGPLOT?

katslau — Tue, 22 Mar 2022 01:33:18 GMT

These work around codes work for me. Now, I'm having the percentage display on the bars (datalabel). Is it possible to limit the decimal places to one only. It's displaying 3 and that's too much.

Thanks.