Re: Merging IR to PR [message #26252 is a reply to message #26245] |
Mon, 27 February 2023 08:39 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
Bridgette-DHS
Messages: 3150 Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS staff member, Tom Pullum:
It's good that you want to study children age 5-15 (or 5-14, which would be more standard; at age 15, household members are eligible for the individual interviews). That age interval is under-studied.
If you want to link these children with their mothers, you are reducing to children who are in the same household as the mother, and if you want the mother's IR data, you are reducing further to mothers whose current age is 15-49. Some mothers of older children will themselves be too old for the individual interview. Those reductions may introduce some bias.
You could start with the BR file, which has one record for each child in the birth histories, and each record includes virtually all of the information on the mother in the IR file. Restrict to children whose age (b8) is in the desired range and who are living with the mother (b9=0) This file will only be missing the information about the child that is in the PR file. You would get that information by merging v001 v002 b16 in the BR file with hv001 hv002 hvidx in the PR file. I think this would be more direct than what you are describing.
Recently I posted a Stata program (see attached) that uses children age 0-17 as cases and merges all the information about them, their mothers, and their fathers, onto a single record. You could adapt that program for your purposes, cutting out the merge with the father's data.
[Updated on: Mon, 27 February 2023 08:39] Report message to a moderator
|
|
|