Home » Topics » Nutrition and Anthropometry » Replicating table counts for children under 5 in Bangladesh DHS
| Replicating table counts for children under 5 in Bangladesh DHS [message #1557] |
Thu, 13 March 2014 10:19  |
annadinnyc
Messages: 9
Registered: March 2014
|
Member |
|
|
Hello,
I am trying to replicate the correct total number of children under 5 for Bangladesh DHS 1999/2000, 2004, 2007, and 2011. As my base, I am using the PR files for 2004, 2007, and 2011 and the KR file for 2000 (since only children of interviewed women were measured/weighed). Also, for 2004 and 2007, I am using the HW files to get the anthro variables related to the new WHO standards, which I merge with the base files.
I found the unweighted (N) and weighted (WN) total counts in the appendix tables on sampling errors (which includes variables for children under 5) in each year's final report.
For 2007 and 2011, I am able to replicate the totals using the following code in the PR file:
keep if hc1<=59 & hv103==1 & hc70<9000 // child<5, slept in HH last night, non-missing new WHO standards
* get unweighted total
count
* get weighted total, where weight=hv005/1000000
egen N=total(weight)
sum N
QUESTION: I need help getting the correct totals for 2004 and 1999/2004.
(1) Table 11.7 in the 2004 final report says that "children who stayed in the household the night before the interview" and "who have a valid date of birth (month and year) and valid height and weight measurements" are included. Here is the code that I am trying:
keep if hv103==1 & hc33==1 & hc13==0 // slept in HH last night, age info complete, measured
This gives me 6142 unweighted total and 6132 weighted total but the report gives 6012 unweighted and 6005 weighted.
There are several missings (e.g., hc7==9980) for some of the anthro variables, but not all (which is confusing since weight, height and age are supposedly complete). I tried dropping children who are missing some of the anthro variables (hc4 hc12), but I can't get the exact number of children from the table.
(2) Table 9.5 in the 1999-2000 final report only says that the "figures are for children born in the period 0-59 months preceding the survey". If I only keep those who were measured (using code below), I get 5562 unweighted and 5652 weighted, but the report gives 5335 unweighted and 5421 weighted.
keep if hc13==0 / measured
I tried dropping children who are missing some of the anthro variables (hc4 hc12), but I can't get the exact number of children from the table.
Any suggestions would be very much appreciated. Thank you.
Anna
|
|
|
|
Current Time: Wed Nov 27 17:42:06 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
