Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 11

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

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.

Frequent Contributor
Posts: 117

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

Are you doing it in proc report or something else

Occasional Contributor
Posts: 11

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

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 

Frequent Contributor
Posts: 117

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

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

SAS Super FREQ
Posts: 8,719

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

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

Ask a Question
Discussion stats
  • 4 replies
  • 326 views
  • 0 likes
  • 3 in conversation