topic Re: vbar display both % and count in Graphics Programming

vbar display both % and count

capam — Wed, 07 Nov 2018 19:26:45 GMT

Hi,

I'd like to display on a single plot using vbar or similar labeling with both percentage and frequency count displayed. I use sas 9.4.

Code I have is:

proc sgplot data=have noborder;
yaxis label= "Counts";
vbar var/GROUPORDER=ascending stat=percent datalabel;
run;

How can I modify it to add counts?

Thanks.

Re: vbar display both % and count

DanH_sas — Wed, 07 Nov 2018 20:08:18 GMT

See if this will work for you:

proc sgplot data=sashelp.class noborder;
yaxis label= "Counts";
vbar age/GROUPORDER=ascending stat=percent datalabel;
xaxistable age / location=inside stat=freq;
run;

Hope this helps!

Dan

Re: vbar display both % and count

capam — Wed, 07 Nov 2018 20:29:42 GMT

Thanks Dan for the quick response.
I tried it and it duplicated the items on the x-axis and did not add a percentage.
capam

Re: vbar display both % and count

capam — Wed, 07 Nov 2018 20:41:45 GMT

Sorry, it kept the percentage, but did not add a freq.

Re: vbar display both % and count

DanH_sas — Wed, 07 Nov 2018 20:42:55 GMT

I get the percent labels on the bars and the freq values in the axis table. What version of SAS 9.4 do you have? Please run this and let me know what the log says:

%put &sysvlong;

Thanks!
Dan

Re: vbar display both % and count

capam — Wed, 07 Nov 2018 20:49:34 GMT

version 7.100.3.5419

Re: vbar display both % and count

capam — Wed, 07 Nov 2018 20:53:11 GMT

64 %put &sysvlong;
9.04.01M3P062415

Re: vbar display both % and count

DanH_sas — Wed, 07 Nov 2018 21:23:10 GMT

In the example, the freq values are along the bottom of the bars. I get this with 9.4m3 as well: They can be also moved to the top of the graph.

Re: vbar display both % and count

capam — Wed, 07 Nov 2018 21:41:07 GMT

In my code it repeats the x axis label, rather than counts as in your example.

Re: vbar display both % and count

DanH_sas — Wed, 07 Nov 2018 22:10:02 GMT

In that case, just add LABEL="Frequency" to the XAXISTABLE statement (after the "/").

Re: vbar display both % and count

DanH_sas — Wed, 07 Nov 2018 22:12:15 GMT

Or, are you saying that it just repeats 11, 12 13, 14, 15, and 16?

Re: vbar display both % and count

capam — Thu, 08 Nov 2018 12:34:42 GMT

Yes. Thanks for the post on labeling, but that's not my main concern. For some reason it is not displaying the count values only the labels as you stated above.

Re: vbar display both % and count

DanH_sas — Mon, 12 Nov 2018 15:36:16 GMT

Try this and see if it works for you:

In a small datastep, copy your category column to another column (such as age2, in this example.) Use age2 in the XAXISTABLE instead.

data class;
set sashelp.class;
age2=age;
run;

proc sgplot data=sashelp.class noborder;
yaxis label= "Counts";
vbar age/GROUPORDER=ascending stat=percent datalabel;
xaxistable age2 / location=inside stat=freq label="Frequency";
run;