The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Combining mother's info on child row in PR file
Re: Combining mother's info on child row in PR file [message #11349 is a reply to message #11339] Wed, 07 December 2016 18:56 Go to previous messageGo to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 805
Registered: January 2013
Senior Member
When I looked at the data in detail, I do see the problem case that you pointed out, and I see some other cases with issues, but I do not see anything like as many as you do. I used (I think) a slightly tighter check than you did - Mothers aged less than 12 years older or more than 60 years older than the child - and I only found 37 cases (see attached file). I think there are three main types of problems:
1) Reporting of the correct person as the mother. If the line number of the mother is recorded incorrectly, then the age of the mother is going to look incorrect. This probably accounts for many of the problems, particularly those where the "Mother's" age is under 10, or the age difference is less than 10.
2) Some women are reported as much older than they are - there certainly appear to be a few of these cases, e.g. where the mother is reported as age 70.
3) Age of mother is reported too young, and the gap between the age of the mother and the child is too small. There are likely to be a few of these too.

I looked at a few other datasets, and I find a few cases of problems here and there, but not many. The Mali DHS 2001 has more than most, but I only identified 37 cases with my check.

Can you check your logic again and make sure you are not incorrectly identifying problem cases. Also, remember that 98 or 99 mean Don't know and Missing respectively for variable hv105, and should be excluded from the checking.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: combinning three files into one file
Next Topic: Child's weight in Kg (1 decimal) variable in SAS
Goto Forum:
  


Current Time: Fri Jan 3 02:39:20 Coordinated Universal Time 2025