Output Delivery System: The Basics and Beyond

Adding Traffic Lighting to PROC TABULATE Table Values

Just as in the earlier example for PROC REPORT, colors can be applied to different ranges of PROC TABULATE table values. If you're creating a large table, this technique is great for focusing thereader's attention on the key results. You use red for bad results, yellow for neutral results, and green for good results. In this example, we take our familiar table and use traffic lighting to mark low pricesin green, high prices in red, and prices in between in yellow.

The first thing we need to do is create a format that assigns the value ranges for PRICE to the desired colors. This is very different from the previously discussed PROC REPORT approach. The threecolor settings are RGB values for ...