The SAS Output Delivery System and reporting techniques

Traffic lights on MAX

Not applicable
Posts: 0

Traffic lights on MAX

Dear all,
with a specific format you can assign a color to a range of values.
I would like to give the MAX value a specific color. This value can be 3 or 3000.
In the past i have seen examples to accomplish this by searching for the max value and give all cells with this value a color.
Perhaps with the latest release 9.1.3 SP4 there is a nicer solution??

Frequent Contributor
Posts: 103

Re: Traffic lights on MAX

Posted in reply to deleted_user
If you're using PROC REPORT, you could find the max val;ue in a COMPUTE BEFORE, and set the color for the appropriate row(s) with a CALL DEFINE in a compute block for the appropriate column.
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation