topic Re: change yaxis in sgplot vbar in Graphics Programming

change yaxis in sgplot vbar

echoli — Fri, 17 Mar 2017 15:37:09 GMT

Hi All,

How can I change yaxis in the vbar figure? I don't need frequency, I need percentage. But I don't have a percentage column in dataset, I can got it by proc freq.

here is my code for figure:

proc freq data=lin_;
tables binary*groups;
run;

proc sgplot data=lin_;
vbar binary / group = groups groupdisplay = cluster;
run;

any idea?

Thanks,

Chen

Re: change yaxis in sgplot vbar

Rick_SAS — Fri, 17 Mar 2017 15:43:04 GMT

Here is a link to the doc for the VBAR statement. If you search for "percent" on that page you will find the STAT=PERCENT option.

Re: change yaxis in sgplot vbar

DanH_sas — Fri, 17 Mar 2017 15:43:17 GMT

If you use STAT=PCT on the VBAR statement, do you get what you want?

Re: change yaxis in sgplot vbar

echoli — Fri, 17 Mar 2017 17:50:22 GMT

Hi Rich,

I tried to use stat=percent option, but what if I just want col percent for Y axis? Any way to solve this?

Thanks,

Chen

Re: change yaxis in sgplot vbar

DanH_sas — Fri, 17 Mar 2017 17:58:49 GMT

If you have a column called "percent", do this instead:

proc sgplot data=lin_;
vbarparm x=binary y=percent / group = groups groupdisplay = cluster;
run;

Re: change yaxis in sgplot vbar

echoli — Fri, 17 Mar 2017 18:04:57 GMT

I got group percentage, but I just want col percentage in Y axis.

Thanks,
chen