topic Re: Dual axis bar chart with different categories in Graphics Programming

Dual axis bar chart with different categories

priscilabaddouh — Mon, 05 Feb 2018 04:25:59 GMT

I would like to know how I can create a dual axis bar chart with different categories using SAS commands. I am attaching an image that is an example of what I need to do. The example is very accurate, except that I do not need the line graph. Since I am using private data, I cannot upload the data set or my commands. I would truly appreciate any help.

Re: Dual axis bar chart with different categories

Damo — Mon, 05 Feb 2018 10:19:38 GMT

Hi @priscilabaddouh

Did you have a look at Sample 41975: Annotate a right vertical axis on PROC GCHART output, it should help you.

This is the output of the sample.

And you can always use @GraphGuy page Robert Allison's SAS/Graph Examples! which has more examples that you can think of (or Graphics Samples Output Gallery).

Hope that helps.

Cheers,

Damo

Re: Dual axis bar chart with different categories

ballardw — Mon, 05 Feb 2018 16:02:04 GMT

@priscilabaddouh wrote:

I cannot upload the data set or my commands.

The data I agree can be sensitive. If you have sufficient information in program code to violate any sensitivity rules I would be very skeptical though. Or change the name of your data set from sensitivename to genericname (HAVE is frequently used on this forum for any existing data set) and similar for variable names.

Re: Dual axis bar chart with different categories

DanH_sas — Mon, 05 Feb 2018 18:38:37 GMT

This should work for you:

proc sgplot data=sashelp.class;
yaxis refticks=(label values);
vbar age / response=weight stat=sum group=sex;
run;

Thanks!

Dan

Re: Dual axis bar chart with different categories

Jay54 — Mon, 05 Feb 2018 20:55:59 GMT

See new Graphically Speaking article inspired by your question.

https://blogs.sas.com/content/graphicallyspeaking/2018/02/05/dual-response-axis-bar-line-overlay-part-1/

Re: Dual axis bar chart with different categories

priscilabaddouh — Tue, 06 Feb 2018 19:20:35 GMT

Thank you so much. I could not be more thankful. Have an amazing day!