Date: Wed, 12 Jul 2006 18:16:16 -0500
Reply-To: Pavlo Row <pavlo@INORBIT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Pavlo Row <pavlo@INORBIT.COM>
Subject: Compare two data sets
Content-Type: text/plain; charset="iso-8859-1"
I have two data sets call them A and B. Both of them have the same exact field names:
A has about 15 such fields but 2.5 million records. Same with B.
I wish to compare the values in the two data sets to make sure they agree.
For example, income in A and B don't agree. Flag this somehow with a FLAG = 1 or something like this.
For example, state in A and B do agree. Flag this somehow with a FLAG = 0 or something like this.
How can I(efficiently) do this using SAS V8.2 or V9.
Play 100s of games for FREE! http://games.mail.com/