Date: Fri, 20 Nov 2009 11:06:05 -0800
Reply-To: Tom Abernathy <tom.abernathy@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Tom Abernathy <tom.abernathy@GMAIL.COM>
Subject: Re: Finding differences between records with same key in a big
dataset (lots of fields)
Content-Type: text/plain; charset=ISO-8859-1
Split the data (or make views that split it) and use proc compare.
data one two;
if first.key_field then output one;
else output two;
proc compare data=one compare=two;
On Nov 20, 1:56 pm, Ajay <ajay.on....@gmail.com> wrote:
> I am looking for some easy way to find differences between two records
> having the same key. The dataset contains several hundred variables,
> so i dont want to name the fields..
> Data is something like the following...
> Key_Field Field_1 Field_2 Field_3 ............
> Key1 a b c
> Key1 a b not-c
> Key2 x y z.
> Key2 x not-y z...
> in the above, i would like to come up with something like following
> (basically for each key identifying fields that have mismatches)..
> Key1 and Field_3
> Key2 and Field_2 and so on..
> Any inputs, would be highly appreciated!