The SAS Output Delivery System and reporting techniques

Traffic lights on MAX

Reply
N/A
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??

Regards,
Herman
Frequent Contributor
Posts: 102

Re: Traffic lights on MAX

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
  • 109 views
  • 0 likes
  • 2 in conversation