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"

Hello All,

I have two data sets call them A and B. Both of them have the same exact field names:

A
income  3456
state   CA
zip     02345
score   34AC5

B
income  1234
state   CA
zip     02345
score   34AC6

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.

pavlo


--
___________________________________________________
Play 100s of games for FREE! http://games.mail.com/