Add color to the report based on the cell value

sas_newbie3 — Sun, 20 Nov 2016 21:14:39 GMT

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.

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

Reeza — Sun, 20 Nov 2016 21:49:15 GMT

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

topic Add color to the report based on the cell value in SAS Programming

Add color to the report based on the cell value

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