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
Look at Proc Compare for starters.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.