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?
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.
SAS INNOVATE 2024
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.