The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » anemia prevalence (mismatch after merging PR&KR datasets)
anemia prevalence [message #18502] Tue, 10 December 2019 14:52 Go to next message
zelalem is currently offline  zelalem
Messages: 7
Registered: November 2019
Dear all
l am analysing Ethiopian DHS 2016 PR&KR 71FL data sets after merging. My question is that after merging data sets to determine the prevalence of anemia and associated factors on children aged 6-59 months, the figure on children matches with the report, but when l am analysing maternal factors the figure has significant difference with that of the child's count. ls it normal? l am thinking of as it is missing data. ls it necessarily should balance with that of child's figure? one thing that l have read is that on guide to DHS statistics manual, lt says that children whose mothers are not listed in the household questionnaire are excluded. l am understanding it as the count for children involved for anemia testing should match with their corresponding mothers count. so if this is the case can l get answers from any one here in the forum. lf it is not the case & there is no need to match the child's count with their mothers count, l am waiting for your favorable reply.
Thank you!

[Updated on: Tue, 10 December 2019 14:56]

Report message to a moderator

Re: anemia prevalence [message #18839 is a reply to message #18502] Thu, 27 February 2020 17:32 Go to previous messageGo to next message
Messages: 1516
Registered: February 2013
Senior Member
Dear User, Try looking at this link. It contains Stata code to produce Demographic and Health Survey Indicators.
Re: anemia prevalence [message #18844 is a reply to message #18502] Fri, 28 February 2020 10:56 Go to previous message
Messages: 1516
Registered: February 2013
Senior Member
Dear User, a response from data processing specialist, Albert Themme:

When matching the PR data (based on the household schedule) with information from the KR file (based on children 0-59 months old in the woman's questionnaire) you can have 2 situations with missing data:

1) The child is in the PR file, but the mother was not interviewed and this child can thus not be found in the KR file.
2) The child 0-59 months is in the KR file, but has died or lives somewhere else and can thus not be found in the PR file.

You can exclude the children who have died or do not live in the household (b16 = 0) from the KR file before linking and this should eliminate 2).
But you should always have some children in the PR file without corresponding information in the KR file.

I hope this helps.

Previous Topic: The number of children under five is different between the DHS report and the data file
Next Topic: Complete Vaccination
Goto Forum:

Current Time: Sun Jul 21 03:52:24 Coordinated Universal Time 2024