Hi:
One way around having to specify values in the COMPUTE block is to use a user-defined format, as shown here:
I based the format on the first character of the name field in the SASHELP.CLASS file. The variable I created was called ALFA. Your format would have the dataset names and the colors you choose. I picked 4 colors. You could pick 2 different colors. In the PROC REPORT code, the ALFA column is a NOPRINT column, so it is available to be used, but does not display on the report. This kind of trafficlighting should also work in ODS EXCEL. Without any example data, it is hard to do more than make general suggestions.
Cynthia
... View more