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
