I wonder if there is a way to automatically change the colours of pattern statement in proc gchart. E.g if the value of chart variable is negative then display the bar chart in red, otherwise in green (like traffic lights method).
Thanks.
Hi:
In this Tech Support note, they "pre-test" the values in the data to create macro variables which will be used to set the colors of the bars based on what is in each of the BY group values. So you could use a similar technique to set PATTERN statements for your scenario.
http://support.sas.com/kb/24/874.html
This description of how the PATTERN statement works is very useful -- you have to understand the behavior of PATTERN when a color is specified vs when a color is NOT specified and how the PATTERN statement can be "cycled":
http://support.sas.com/documentation/cdl/en/graphref/63022/HTML/default/viewer.htm#patternchap.htm
cynthia
Hi:
In this Tech Support note, they "pre-test" the values in the data to create macro variables which will be used to set the colors of the bars based on what is in each of the BY group values. So you could use a similar technique to set PATTERN statements for your scenario.
http://support.sas.com/kb/24/874.html
This description of how the PATTERN statement works is very useful -- you have to understand the behavior of PATTERN when a color is specified vs when a color is NOT specified and how the PATTERN statement can be "cycled":
http://support.sas.com/documentation/cdl/en/graphref/63022/HTML/default/viewer.htm#patternchap.htm
cynthia
Cynthia,
Thanks a lot for this, I adapted it to my code and it works very well!
Much appreciate it,
Fethon
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.