Bargraph with an Axis of Percent

[DavidPhillips2]

Does SAS 9.2 have the ability to display a Bargraph with an Axis of percent?  My goal is to show a percent comparison of variable ‘Status’.  Like the below image.  The code would theoretically look something like this.

  proc gchart data=enrollment;

       hbar enrRepTy /

       type=percent

       inside=subpct

       sumvar=STUDENTS_ENROLLED

       pctsum

       subgroup=Status

       discrete

       gaxis=axis1 maxis=axis2 raxis=axis3

       legend = legend1;

  run; Quit;

[DavidPhillips2]

What I could do is make a summary dataset that has the percentages hard coded rather than attempting to calculate the percentage when making the graph.  It is highly likely there is a built in function for this though.

[Reeza]

Can you provide sample data?

[ballardw · Accepted solution]

http://robslink.com/SAS/democd7/aaaindex.htm

Has some examples that should get you started.

A common theme has to do with the AXIS definition in the values part and format chosen.

[DavidPhillips2]

Ballardw, I found this in one of the examples in your link.  It is straight forward.

data my_data;

input CATEGORY SERIES $ 3-11 AMOUNT;

datalines;

1 Series A  5.0

2 Series A  6.8

3 Series A  9.2

1 Series B  6.5

2 Series B  6.9

3 Series B  5.6

1 Series C  2.3

2 Series C  3.1

3 Series C  2.3

;

run;

proc sql;

create table my_data as

select *, sum(amount) as bartotal

from my_data

group by category;

quit; run;

data my_data; set my_data;

format catpct percent6.0;

catpct=amount/bartotal;

run;

data my_data; set my_data;

length htmlvar $500;

htmlvar=

'title='||quote(

  'Category: '||trim(left(category))||'0D'x||

  'Series: '||trim(left(series))||'0D'x||

  'Amount: '||trim(left(amount))||'0D'x||

  'Percent: '||trim(left(put(catpct,percent6.0)))||' of '||trim(left(bartotal))

  )||

' href="bar6_info.htm"';

run;

proc gchart data=my_data;

hbar category / discrete type=sum sumvar=catpct nostats nolegend

subgroup=series /* this controls the coloring */

autoref clipref cref=graycc space=4.0

maxis=axis1 raxis=axis2

cframe=white coutline=black

html=htmlvar

des='' name="&name"; 

run;

[DanH_sas]

SAS 9.4m2  supports everything you want via PROC SGPLOT (see below). SAS 9.4 supports everything but the segment labels. At SAS 9.2, you will need to pre-summarize as you suggested.

Title "Total Class Weight by Percentage";

proc sgplot data=sashelp.class;

hbar age / response=weight stat=pct group=sex seglabel;

run;