Merging HW to IR for Mali DHS IV - Missing HWCASEID [message #15197] |
Fri, 15 June 2018 05:01 ![Go to next message Go to next message](/theme/default/images/down.png) |
bcleite
Messages: 7 Registered: June 2018
|
Member |
|
|
Hi all,
I am using children anthropometrics for Mali DHS surveys. I notice that this information is available, in the Individual Recode (IR), only for the surveys V and VI. I am also interested in this information from the surveys III and IV. For the latter, IV, I downloaded the Height and Weight Scores (HW) and want to match it to the IR so to match with household/mother/children characteristics. Upon downloading it, I learned from the MERGE.DOC document that the variable that merges both datasets is called HWCASEID.
Nevertheless, this variable is not available for that survey's Height and Weight Scores (MLHW41FL.DTA). Has anyone experienced the same issue? Should I merge it with the other variables (hwhhid, hwline or hwlevel)?
Best,
Bruno
|
|
|
|
|
|
Re: Merging HW to IR for Mali DHS IV - Missing HWCASEID [message #15376 is a reply to message #15227] |
Sun, 08 July 2018 21:50 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
kingx025
Messages: 95 Registered: August 2016 Location: Minneapolis. Minnesota
|
Senior Member |
|
|
You can save yourself some work (not doing the merging yourself) if you use IPUMS-DHS (available for free at www.idhsdata.org), which has done the merging for you. Selecting children as the unit of analysis (KR file as starting point), and limiting sample selection to the surveys for Mali 1987, 1995, 2001, 2006, and 2012, I see that there are child anthropometric variables for all the Mali samples.
Sometimes for early years, the height/weight data for children are stored in a separate file. IPUMS-DHS staff have merged these separate anthropometric files to the KR child files. We have also merged the mother's file and the mother's household file to each child record (in the KR files) and each birth record (from the BR files). Thus, you can get all the variables you need, from the household, from the mother, from the child file, and from the child biometric data, if you choose children as the unit of analysis in IPUMS-DHS and select the variables you need. Here's the list of variables relating to child anthropometry when children are selected as the unit of analysis (from the KR files): https://www.idhsdata.org/idhs-action/variables/group?id=kida nthro_kidanthro
Look for columns headed with Mali and the survey year. An X means the variable is available in that sample.
You can log in with your DHS user name and password, select the samples and variables you need and the file format you prefer to make a customized data file, and download it to your computer for analysis without doing any merging yourself.
Keep in mind that only children with surviving mothers who participated in the survey are covered if you use the KR file data (use children as the unit of analysis).
Miriam King
Dr. Miriam King
IPUMS-DHS Project Manager (www.idhsdata.org)
|
|
|
|