I am creating a report for error checking data entry. I have multiple columns where the dates should all match to reflect that each assessment was completed on the same day. I am trying to create a report that will highlight "Which of these things is not like the others".
I am currently highlighting all of the visits where the dates do not match, but I would like to be able to highlight only the fields that are dissimilar to the others.
Here is my current code in my proc report data step.
compute date4;
if date1 ne date2 or date2 ne date3 or date3 ne date4 then do;
call define("date1", 'style', 'style=[foreground=red font_weight=bold]');
call define("date2", 'style', 'style=[foreground=red font_weight=bold]');
call define("date3", 'style', 'style=[foreground=red font_weight=bold]');
call define("date4", 'style', 'style=[foreground=red font_weight=bold]');
end;
endcomp;