a percentage-based bar graph

[dustychair]

Hi all,

I have a categorical variable in my data. I am trying to draw a bar graph for this variable based on the percents. The below code is working but the sum of percentages is not 100%. I don't know how it is calculating this. Is there an easy way to draw a percentage-based bar graph?

Thank you,

proc sgplot data=alt_listening;
title "Proficiency Level: List 1-2";
vbar listening_pl / stat=pct transparency=0.25 fillattrs=(color=black) ;
yaxis label= 'Percent' ;
xaxis label= 'Proficiency Level';
by cluster_listening;
run;

[djrisks]

Hello,
Please can you also include your data or an example of your data?

[dustychair · Accepted solution]

Thank you for your response. I think I got it. I modified my code as below and it worked.

proc sgplot data=alt_listening PCTLEVEL=BY;
title "Proficiency Level: List 1-2";
vbar listening_pl / stat=pct transparency=0.25 fillattrs=(color=black) ;
yaxis label= 'Percent' ;
xaxis label= 'Proficiency Level';
by cluster_listening;
run;

Thank you again

[DanH_sas]

For the record, the default percentage basis is the entire graph output, including all BY-groups. To change this basis, use the PCTLEVEL option like you did set the level you want to be the basis for 100%. In SGPLOT, there are three levels: Graph (the default), BY (for BY-groups), and Group (all groups within a category = 100%). For SGPANEL, there are four levels: Graph, BY, Cell (all bars in each cell = 100%), and Group.