house - Household data Heres an example(from Statas...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Household data Here’s an example (from Stata’s listserv) of the challenges in manipulating data for households & members: Date: Mon, 28 Feb 2005 00:59:19 -0500 From: "Kakatua Kutta" <[email protected]> Subject: st: data manipulation problem Dear stata maestros, I have a following data set nh pid sid age educ 1 1 2 34 3 1 2 1 29 2 1 3 . 21 2 1 4 . 27 1 2 1 3 44 12 2 2 . 23 9 2 3 1 31 11 2 4 . 19 2 2 5 . 27 3 . . . nh is the household identification no and pid is individual identification within each household. Sid is the spouse identification no for those people who are married within a household. So for nh=1, it means pid 1 and 2 are married to each other and for nh=2, pid 1 and 3 are married to each other. What I want to do is to make a datasets consisting of household members married to each other. That is, in the new data set I want to keep , for nh=1, pid 1 and 2 and for nh=2, pid 1 and 3. So what I am trying to find that for each nh, take those pid for which sid equals pid from others observations. Is there anyway to do it rather than going through each observation individually? - ---------------------------------------------------- In addition to yesterday's response (which suggested keeping respondents with non-missing sid values) . .. It sounds as if you eventually wish to (a) create within-household partnership identifiers, and then (b) attribute values for one spouse to the other spouse. This is relatively straightforward, but there are many
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/11/2011 for the course SYA 6306 taught by Professor Tardanico during the Spring '09 term at FIU.

Page1 / 4

house - Household data Heres an example(from Statas...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online