LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 1999, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 -------------------------------------------------

Back to: Top of message | Previous page | Main SAS-L page