topic Re: How to change the color of value in one column in the Summary table, depending on the value in the other column? in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187865#M14408 <HTML><HEAD></HEAD><BODY><P>I am not sure that we can match two variables and do color coding over it in proc tabulate. I do use proc report.</P></BODY></HTML> Mon, 02 Mar 2015 14:28:26 GMT Vish33 2015-03-02T14:28:26Z How to change the color of value in one column in the Summary table, depending on the value in the other column? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187862#M14405 <HTML><HEAD></HEAD><BODY><P>ofH</P><P>I have two columns in the table, for example weight1 and weight2. I have to highlight weight2 in the summary table as:&nbsp; red if it is less&nbsp; then weight1,&nbsp; green if it is great then weight1 and blue if they are equal.</P><P>Is there any solution for this case?&nbsp;&nbsp;&nbsp; </P><P></P><P>Thank you in advance.</P></BODY></HTML> Mon, 02 Mar 2015 10:24:07 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187862#M14405 NataljaK 2015-03-02T10:24:07Z Re: How to change the color of value in one column in the Summary table, depending on the value in the other column? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187863#M14406 <HTML><HEAD></HEAD><BODY><P>Are you doing it in proc report or something else</P></BODY></HTML> Mon, 02 Mar 2015 11:46:31 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187863#M14406 Vish33 2015-03-02T11:46:31Z Re: How to change the color of value in one column in the Summary table, depending on the value in the other column? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187864#M14407 <HTML><HEAD></HEAD><BODY><P>I do it in proc tabulate. I know how to do this in proc report, but&nbsp; I am more familiar&nbsp; to work with tabulate because SAS EG has this task in the menu&nbsp; </P></BODY></HTML> Mon, 02 Mar 2015 12:50:14 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187864#M14407 NataljaK 2015-03-02T12:50:14Z Re: How to change the color of value in one column in the Summary table, depending on the value in the other column? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187865#M14408 <HTML><HEAD></HEAD><BODY><P>I am not sure that we can match two variables and do color coding over it in proc tabulate. I do use proc report.</P></BODY></HTML> Mon, 02 Mar 2015 14:28:26 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187865#M14408 Vish33 2015-03-02T14:28:26Z Re: How to change the color of value in one column in the Summary table, depending on the value in the other column? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187866#M14409 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>cynthia</P></BODY></HTML> Tue, 03 Mar 2015 04:28:20 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-change-the-color-of-value-in-one-column-in-the-Summary/m-p/187866#M14409 Cynthia_sas 2015-03-03T04:28:20Z