BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Pyrite | Level 9

## a percentage-based bar graph

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;``````

1 ACCEPTED SOLUTION

Accepted Solutions
Pyrite | Level 9

## Re: a percentage-based bar graph

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
3 REPLIES 3
Barite | Level 11

## Re: a percentage-based bar graph

Hello,
Please can you also include your data or an example of your data?
Pyrite | Level 9

## Re: a percentage-based bar graph

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
SAS Super FREQ

## Re: a percentage-based bar graph

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.

Discussion stats
• 3 replies
• 480 views
• 5 likes
• 3 in conversation