Modifying colours for PATTERN statement

[PTD_SAS]

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.

[Cynthia_sas · Accepted solution]

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

[PTD_SAS]

Cynthia,

Thanks a lot for this, I adapted it to my code and it works very well!

Much appreciate it,

Fethon