sgplot barchart with n on y-axis and % floating over the bars

[telligent]

How do I make a bar chart with N on the y-axis, a category on the x-axis and percent as a label on the bars without creating an output data set with proc freq or something similiar. Just using raw data. . . 

Thank you.  

[Reeza · Accepted solution]

The hacky method that comes to mind is overlaying two plots, one with invisible bars that shows the percentages on a non-shown dual axis. So the labels will come from one plot and the data/bars from another. You will need to customize your legend using keylegend - I'm leaving that for you.

proc sgplot data=sashelp.class;
hbar sex / stat=freq;
hbar sex / stat=percent x2axis datalabel nooutline;
x2axis display=none;
run;

---

@telligent wrote:

How do I make a bar chart with N on the y-axis, a category on the x-axis and percent as a label on the bars without creating an output data set with proc freq or something similiar. Just using raw data. . . 

Thank you.  

---

FYI - replace HBAR with VBAR and X2AXIS with Y2AXIS for a vertical layout.

[telligent]

Thank you!

[Reeza]

Show your code.
I got those results when I didn't set up the x2/y2 axis correctly.

[telligent]

proc sgplot data=one noautolegend;
vbar q1 / stat=freq;
xaxis display=(nolabel) ;
vbar q1 /stat=percent x2axis datalabel nooutline;
x2axis display=none;
yaxis integer max=&n;
run;

[Reeza]

You changed HBAR but missed the change of X2AXIS to the Y2AXIS.
So that statement doesn't actually make sense.

[telligent]

I noticed the statement below that I added throws the whole thing off. When I do this the bar heights are wrong relative to the y axis. Do you have any suggestions for me?  I want the y-axis to go up to a certain level and the bar heights to still be correct. Thank you. 

yaxis integer max=100;

[Reeza]

I'm guessing you didn't set both axis to the same or overwrote your prior YAXIS statement. But with just a single line of code that's an example, post your code, log and the sample output please.