Home » Data » Merging data files » Merging KR with PR for Ethiopia 2011
Re: Merging KR with PR for Ethiopia 2011 [message #15378 is a reply to message #14997] |
Sun, 08 July 2018 23:04 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to previous message](/theme/default/images/down.png) |
kingx025
Messages: 95 Registered: August 2016 Location: Minneapolis. Minnesota
|
Senior Member |
|
|
If I am understanding correctly, you want to merge the KR and PR files for Ethiopia 2011 to replicate the categories in Table 10.7 of the final report, with information on diarrhea from the KR files and household characteristics taken from the PR files. A simpler approach, in my opinion, is simply to merge the household record for the child's mother to the KR file. IPUMS-DHS has already done this for you; for the KR (child) and BR (birth) files, we have merged the mother's record from the IR file and the mother's household record. Thus, you can get all the variables you need if you choose "children" as your unit of analysis and select the following variables in IPUMS-DHS:
Child's age in months: HW1 (KIDAGEMO) https://www.idhsdata.org/idhs-action/variables/KIDAGEMO#code s_section
Child's sex: B4 (KIDSEX) https://www.idhsdata.org/idhs-action/variables/KIDSEX#codes_ section
HH source of drinking water: HV201 (DRINKWTR): https://www.idhsdata.org/idhs-action/variables/DRINKWTR#code s_section
Type of HH toilet facility: HV205 (TOILETTYPE): https://www.idhsdata.org/idhs-action/variables/TOILETTYPE#co des_section
Toilet facility shared: HV225 (TOILETSHAREYN); https://www.idhsdata.org/idhs-action/variables/TOILETSHAREYN #codes_section
Urban-rural residence: V025 (Urban) https://www.idhsdata.org/idhs-action/variables/URBAN#codes_s ection
Region of residence: V101_ET2011 (GEO_ET2011): https://www.idhsdata.org/idhs-action/variables/GEO_ET2011#co des_section
Mother's education: V106 (EDUCLVL): https://www.idhsdata.org/idhs-action/variables/EDUCLVL#codes _section
Household wealth quintile: V190 (WEALTHQ): https://www.idhsdata.org/idhs-action/variables/WEALTHQ#codes _section
Child had recent diarrhea: H11 (DIARRECENT): https://www.idhsdata.org/idhs-action/variables/DIARRECENT#co des_section
Blood in child's stools: H11B (DIABLOODST) https://www.idhsdata.org/idhs-action/variables/DIABLOODST#co des_section
Weight: V005 (PERWEIGHT) https://www.idhsdata.org/idhs-action/variables/PERWEIGHT#cod es_section
When you merge the PR and KR data, you have to drop the cases of children not included in the KR file, anyway. The only possible problem that I see is that some of the background variables (on urban residence, region of residence, and wealth quintiles) use the variable from the IR file, rather than the variable from the linked household file, so you may get some results with "non-resident" as a code in your results, which are not in the table. We're planning on adding the household-based version of those variables to the IPUMS-DHS data for women, children, and births by Fall.
You can make a customized data file from IPUMS-DHS (www.idhsdata.org) by logging in with your DHS user name and password, selecting the above variables and ET2011 as a sample for a customized dataset, selecting your preferred data format, and downloading the customized (free) data file to your computer for analysis. You will have to do some recoding of the variable on type of toilet facility, but that would be the case with the original DHS files as well.
I hope this helps.
Miriam King
Dr. Miriam King
IPUMS-DHS Project Manager (www.idhsdata.org)
|
|
|
Goto Forum:
Current Time: Sat Aug 17 05:11:05 Coordinated Universal Time 2024
|