Comparing Data rows

[radha1]

Hi,

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.

in old column and new column contain same data as "0" it should not be highlighted.

old	new
4.05.314
0	0
0	0
0	0
5.772
0	0
0	0
0	0
584	584
7.479	7479
1.130	1130
1.236	1236
928	928

i written the below code,

COL old new;

define old / display;

define new / display;

compute old

if (old ne new) then

call define (_col_,"style","style={background= orange}");

end compute;

[RW9]

Do the comparison in a datastep and set a flag in the data.  Then use a simple proc report to print the data, and us the flag to do the traffic lighting.