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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.