How to change the color of value in one column in the Summary table, depending on the value in the other column?

[NataljaK]

ofH

I have two columns in the table, for example weight1 and weight2. I have to highlight weight2 in the summary table as:  red if it is less  then weight1,  green if it is great then weight1 and blue if they are equal.

Is there any solution for this case?   

Thank you in advance.

[Vish33]

Are you doing it in proc report or something else

[NataljaK]

I do it in proc tabulate. I know how to do this in proc report, but  I am more familiar  to work with tabulate because SAS EG has this task in the menu 

[Vish33]

I am not sure that we can match two variables and do color coding over it in proc tabulate. I do use proc report.

[Cynthia_sas]

Hi, in PROC TABULATE, you can't highlight one column based on the value of another column. But, as you know, this is easy to do with PROC REPORT using the CALL DEFINE statement and a COMPUTE block.

cynthia