The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Uganda » Number of eligible children for height and weight/sampling procedure
Re: Number of eligible children for height and weight/sampling procedure [message #8931 is a reply to message #8763] Fri, 15 January 2016 11:15 Go to previous messageGo to previous message
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
Here is a response from one of our experts, Dr. Tom Pullum:
Unfortunately, hv035 does not identify the eligibility of a specific child. I wish it did. Instead, it is the number of eligible children in the household and it is the same number for every record in the PR file (within the same household), regardless of age, etc. You can open the PR file and enter these lines:

keep if hvidx==1
tab hv035

You will see that there are 843 households with one eligible child, 653 with two, etc. The number of children will be 1*843 + 2*653 + ... = 2656. That, not 1654 or 2705, is the correct number of eligible children.

There is no need to do a merge. In the PR file the height-for-age variable is hc70. It is non-missing for 2636 children, although there are flagged and out-of-range values. The calculation of stunting would just use the hc70 values that are >-600 and <600. In the KR file the height-for-age variable is hw70. It is non-missing for 2214 children, including values that are flagged or out of range. Those 2214 children are the children in the household file whose mother is also in the household file and was interviewed. That is, if the mother has died or does not live in the same household as the child or was not interviewed, then the child who was in the PR file will not also be in the KR file.

DHS tables normally base the stunting (etc.) estimates on the children in the PR file, rather than the somewhat smaller number in the KR file. Children whose mother is not in the same household are generally a little worse off.

I suggest that you read about "_merge", a variable that is constructed whenever you do a merge. Normally you only want cases for which _merge===3, so you include a line "keep if _merge==3". Something else that I often do with complicated merges is to construct a variable that identifies the file. For example, after opening a PR file I will put "gen in_PR=1", and after opening a KR file I will have "gen in_KR=1". Then after the merge I could put "keep if in_PR==1 & in_KR==1", for example. If you do either of these things you should be able to discard the extra cases that are not in both files. I also do not use the new version of merge, with m:1, 1:m, etc., because it is too easy to get reversed and make a mistake.

Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Data Release Date
Next Topic: Wealth Index - Uganda 2000
Goto Forum:

Current Time: Sun Jun 23 03:47:51 Coordinated Universal Time 2024