Add color to the report based on the cell value

Accepted Solution Solved
Reply
Contributor
Posts: 26
Accepted Solution

Add color to the report based on the cell value

[ Edited ]

I want to add the color to the report based on the cell value.

proc format; 
     value  usercolor 1="RED" 2="BLUE" 3="YELLOW"
      4="GREEN" 5="PINK" 6="ORANGE"
      7="MARRON" 8="CYAN";
run; 

Ods html body="c:\report.html";
Proc report data=myfile.info;
   column Name A1 A2 A3 A4 A5 A6 A7 A8; 
   define A1 / display style={Backgroundcolor=usercolor};
   define A2 / display style={Backgroundcolor=usercolor};
   define A3 / display style={Backgroundcolor=usercolor};
   define A4 / display style={Backgroundcolor=usercolor};
   define A5 / display style={Backgroundcolor=usercolor};
   define A6 / display style={Backgroundcolor=usercolor};
   define A7 / display style={Backgroundcolor=usercolor};
   define A8 / display style={Backgroundcolor=usercolor};
   define Adventure / display style={Backgroundcolor=usercolor};
run;
ods html close;

The values in the cells are 1~9 or just missing value.

However the colors are not added at all.

 

 

 


Accepted Solutions
Solution
‎11-20-2016 05:04 PM
Grand Advisor
Posts: 17,336

Re: Add color to the report based on the cell value

When using a format, it needs to end with a period.

 

define A1 / display style={Backgroundcolor=usercolor.};

See this paper here for other options:

http://support.sas.com/resources/papers/proceedings13/366-2013.pdf

View solution in original post


All Replies
Solution
‎11-20-2016 05:04 PM
Grand Advisor
Posts: 17,336

Re: Add color to the report based on the cell value

When using a format, it needs to end with a period.

 

define A1 / display style={Backgroundcolor=usercolor.};

See this paper here for other options:

http://support.sas.com/resources/papers/proceedings13/366-2013.pdf

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 154 views
  • 0 likes
  • 2 in conversation