topic Re: sgplot barchart with n on y-axis and % floating over the bars in Graphics Programming

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

telligent — Wed, 31 Mar 2021 20:13:10 GMT

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.

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

Reeza — Wed, 31 Mar 2021 20:32:13 GMT

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.

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

telligent — Wed, 31 Mar 2021 21:37:05 GMT

Thank you!

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

Reeza — Wed, 31 Mar 2021 20:51:54 GMT

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

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

telligent — Wed, 31 Mar 2021 20:58:26 GMT

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;

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

Reeza — Wed, 31 Mar 2021 21:01:38 GMT

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

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

telligent — Sun, 02 May 2021 20:06:37 GMT

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;

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

Reeza — Mon, 03 May 2021 03:04:23 GMT

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.