Join two tables - Flag and summarize common variables that have unequal pairs of values

[Nikos]

Dear all,

I join two datasets A and B on two common variables VARA and VARB.

Those two datasets have a number of common variables that after the join should have equal values across all joined records Var1_A = Var1_B, ,Var2_A = Var2_B ...etc.

Unfortunately that is not happening and I would like to summarize all these unequal pairs of values.

VARA   VARB        (  Var1_A   Var1_B )  (Var2_A   Var2_B)  

  100      100                50    .    50              20          20

  200      200                32         .                45         45

  300      300                67         67               .          53

  400      400                 .         72               23         23

...............................................................................

In addition to the above the number of  common variables that have unequal pairs of values  is significant (>100) which makes very cumbersome to search one by one.

Any hints most welcome.

Thank you in aFladvance.

Nikos

[Reeza]

Look at Proc Compare for starters.