Here's one way to do it, using Proc GChart ...
PROC IMPORT OUT=my_data DATAFILE="final.xls" DBMS=XLS REPLACE; GETNAMES=YES; RUN;
proc sql; create table my_data as select unique *, sum(c) as sum_c from my_data group by group_y_name, proj_r; quit; run; data my_data; set my_data; format c_pct percent7.0; c_pct=c/sum_c; run;
proc format; value rankfmt 1 = "1st Ranked" 2 = "2nd Ranked" 3 = "3rd Ranked" ; run;
pattern1 v=s c=cxfad9b8; pattern2 v=s c=cxadd8e6; pattern3 v=s c=cxf9f9cf;
axis1 style=0 label=none major=none minor=none value=none offset=(0,0); axis2 label=none; axis3 label=none;
legend1 label=none;
goptions ftext='albany amt/bold' htext=11pt ctext=gray33 htitle=14pt;
title1 ls=1.5 "Proof-of-Concept Bar Chart"; proc gchart data=my_data; format ranking rankfmt.; vbar proj_r / discrete type=sum sumvar=c_pct space=0 group=group_y_name subgroup=ranking inside=sum raxis=axis1 noframe legend=legend1 maxis=axis2 gaxis=axis3 coutline=white gspace=5; run;
... View more