The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging Rwanda DHS 1992 without b16
Re: Merging Rwanda DHS 1992 without b16 [message #13905 is a reply to message #13894] Tue, 23 January 2018 07:15 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

Note that hv111 and hv113 are included in this survey only for ages 0-14 (hv112 and hv114 are not included at all--you do not mention them but they can be very helpful). In later surveys the age interval is 0-17. These variables are collected in the household survey. The HW variables (hc70-hc73) for this survey were collected in the survey of women (see the variable "hwlevel") and apply to the surviving children of women in the household. Children in the household whose mother had died or for some other reason was not in the household do not have the HW variables.

I can't go into your do file in detail, but I have to say that we at DHS have not been able to find a certain way to link the children in the KR file to the children in the PR file in the early files that did not include b16. I have spent quite a bit of time working on this and so have others. Whoever can figure this out deserves a prize!

In the later surveys, not only is b16 included, but the age of the child in months (for children under 5), is included as hc1 and it can also be calculated as v008-b3. This gives an exact correspondence between the ages of children in the PR and KR files, in months, which would be a big help if you wanted to match specific children. But in the older surveys, not only is b16 omitted, but hc1 is also omitted, and the age of a child in years in the PR file, hv005, is fairly often inconsistent with the age in years in the KR file, b8. I recommend that you use the more recent surveys or re-define your research question in such a way that you can manage without trying to merge the PR and KR files.


 
Read Message
Read Message
Read Message
Previous Topic: Issue merging household and individual (women's) file
Next Topic: Merging Individual and HH Member Recode Files
Goto Forum:
  


Current Time: Thu Mar 28 16:58:28 Coordinated Universal Time 2024