Help using Base SAS procedures

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

Reply
Contributor
Posts: 68

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

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

Super User
Posts: 19,810

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

Look at Proc Compare for starters.

Ask a Question
Discussion stats
  • 1 reply
  • 166 views
  • 0 likes
  • 2 in conversation