topic Re: is it possible to produce bar chart with both frequency and percentage? in SAS Programming

is it possible to produce bar chart with both frequency and percentage?

Abdulla1 — Thu, 17 Nov 2022 15:13:13 GMT

Hello all

I've created the bar chart below, and I wonder if it is possible to let the bar chart show be both the frequency and the percentage ?

code"

PROC SGPLOT DATA = sashelp.cars;
VBAR type /group=origin;
RUN;

function output:

wanted output examples

thanks

Re: is it possible to produce bar chart with both frequency and percentage?

Reeza — Thu, 17 Nov 2022 16:30:39 GMT

What is the denominator for the percentage? Overall or Per type?

Re: is it possible to produce bar chart with both frequency and percentage?

Abdulla1 — Thu, 17 Nov 2022 16:44:19 GMT

if it is possible to do it per type that would be great. 😄

Re: is it possible to produce bar chart with both frequency and percentage?

Abdulla1 — Thu, 17 Nov 2022 18:34:03 GMT

i think in order for it to work with the percentage per type we need to write the value inside each colored portion cause otherwise the percent access needs a different bar as the percentage scale changes along the type
I found a way of adding the percent (out of total) in color like this but this losses the information of what each section of the bar represent (origin data in my example).

I wish I can keep write the percentage (and adjust it to pertype) value in the boxes instead of the frequency.

code :

PROC SGPLOT DATA = sashelp.cars;
VBAR type /group=origin COLORSTAT=PCT SEGLABEL;
RUN;

Re: is it possible to produce bar chart with both frequency and percentage?

Ksharp — Fri, 18 Nov 2022 11:51:54 GMT

PROC SGPLOT DATA = sashelp.cars nocycleattrs;
VBAR type /group=origin;
VBAR type /group=origin y2axis stat=percent ;
RUN;

Re: is it possible to produce bar chart with both frequency and percentage?

Abdulla1 — Fri, 18 Nov 2022 14:50:44 GMT

y2axis

that is just a great option.

thank you .