https://communities.sas.com/t5/SAS-Enterprise-Guide/Comparing-Data-rows/m-p/492256#M31741 <P>Do the comparison in a datastep and set a flag in the data.&nbsp; Then use a simple proc report to print the data, and us the flag to do the traffic lighting.</P> Tue, 04 Sep 2018 12:10:11 GMT RW9 2018-09-04T12:10:11Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Comparing-Data-rows/m-p/492246#M31740 <P>Hi,</P><P>&nbsp;</P><P>I am trying to compare two rows from tables and highlighting mismatch data with color codes, in the output getting color for matched data also see the below example.</P><P>&nbsp;</P><P>in old column and new column contain same data as "0" it should not be highlighted.</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>old</TD><TD>new</TD></TR><TR><TD>4.05.314</TD><TD>&nbsp;</TD></TR><TR><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD></TR><TR><TD>5.772</TD><TD>&nbsp;</TD></TR><TR><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD></TR><TR><TD>584</TD><TD>584</TD></TR><TR><TD>7.479</TD><TD>7479</TD></TR><TR><TD>1.130</TD><TD>1130</TD></TR><TR><TD>1.236</TD><TD>1236</TD></TR><TR><TD>928</TD><TD>928</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i written the below code,</P><P>&nbsp;</P><P>COL old&nbsp;new;</P><P>&nbsp;</P><P>define old / display;</P><P>define new / display;</P><P>compute old</P><P>if (old ne new) then</P><P>call define (_col_,"style","style={background= orange}");</P><P>end compute;</P> Tue, 04 Sep 2018 11:15:53 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Comparing-Data-rows/m-p/492246#M31740 radha1 2018-09-04T11:15:53Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Comparing-Data-rows/m-p/492256#M31741 <P>Do the comparison in a datastep and set a flag in the data.&nbsp; Then use a simple proc report to print the data, and us the flag to do the traffic lighting.</P> Tue, 04 Sep 2018 12:10:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Comparing-Data-rows/m-p/492256#M31741 RW9 2018-09-04T12:10:11Z