Date:         Mon, 29 May 2006 18:49:12 -0400
Reply-To:     Samuel Barnes <samuelbarnes@SYMPATICO.CA>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Samuel Barnes <samuelbarnes@SYMPATICO.CA>
Subject:      How do I find discrepancies when comparing two datasets?

I am using SPSS 14. I don't know if that makes any difference but I thought
I would say it for the record.

Here is my question/problem:
I have two datasets: one larger database consisting of users and non users;
the other was extracted from this database and is just users.  The user
database has had work done on it - its been cleaned and new variables have
been added.  Now when running various descriptive stats and comparing them
between the two spreadsheets, I found that there are 3 more people in the
user dataset than in the larger database it came from.  I have to locate
these three people, compare variables, then insert them into the larger
database.  How do I locate the 3 extra people (comparing the two databases
for the missing people) and then import them into the larger database where
there are more and are in different places.  Is there a way to do this easily?

Thanks