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.
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
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
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.