I would begin with:
case (when a.&var ne b.&var then cat(a.&var, '*' , b.&var else ' ') as &var._diff
There aren't a whole lot of rules when it comes to a character variable being different. So this will capture the differences.
An important question to consider: will there always be exactly 1 observation per ID in both data sets?
... View more