Date:         Tue, 3 Aug 1999 08:23:26 -0400
Reply-To:     "Robert Andrew Bowell Jr." <bowell@NBCS.RUTGERS.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Robert Andrew Bowell Jr." <bowell@NBCS.RUTGERS.EDU>
Subject:      Combining Data Sets while excluding obs
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hi,
        I have a user who needs to combine 2 data sets, a mothers data set
and a daughters data set, which are formatted exactly the same (the same
variables). She wants to exclude from the combined set people who aren't
related to each other.  There's a variable for each observation in both
data sets that codes for what household you live in.  There's also a
variable to code what household your mother lived in.  So what she needs
to do, for a given observation in the daughter data set, is to have SAS
look at the "mother's home" variable, see if it exists in the mother data
set under "home", and if not, drop the observation.  Similarly, for a
given observation in the mothers data set, it needs to look at the "home"
variable and see if it exists within the daughters data set under the
"mother's home" variable.
        Any idea how to do this?

        Y'obt.,
                Rob Bowell
-------------------------------------------------
Programmer/Analyst, RUCS User Services Group
Hill Center, Room 209
Phone: 732-445-0481/Fax: 732-445-5539
-------------------------------------------------