topic Re: How to create average lines in a stacked/grouped graph using Proc Gchart in Graphics Programming

How to create average lines in a stacked/grouped graph using Proc Gchart

ravib — Tue, 09 Feb 2016 16:58:58 GMT

Hi,

I have created a Stacked/Grouped vertical bar charts using Proc GCHART Group & subgroup variables. Please refer screenshot attached with SAS Graphs and Code used. Please note that C= Credit & D=Debit for each customer/month.

On the same graph I want to add two horizontal lines showing the average credit amount & average debit amount across all periods specified. I couldn't do it through ANNO= option available. Is there anyway to achieve it through using Proc Gchart?

Appreciate your help.

Re: How to create average lines in a stacked/grouped graph using Proc Gchart

ballardw — Tue, 09 Feb 2016 17:55:23 GMT

If these are to be horizontal lines you could summarize the data to get the mean you are looking for and look at the REF option.

Re: How to create average lines in a stacked/grouped graph using Proc Gchart

ravib — Tue, 01 Mar 2016 10:39:52 GMT

Hi,

Thanks for the solution and sorry for the late response due to work load.

My REF values need to be dynamically calculated from the input values. So I have created macro variables to calculate and call them in REF= option in Proc Gchart, which has worked well. Thanks once again.

Best Regards

RaviB