The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » No. of U5 in HH coded "0" ?.
No. of U5 in HH coded "0" ?. [message #22143] Sat, 06 February 2021 03:53 Go to next message

I'm working with several child files in West Africa. I'm confused about V137 (number of children under 5 in household) when it is coded "0". There is at least one child in the household because he/she has a record. In fact, sometimes a respondent will have several children under 5, but V137 is still coded 0 (e.g., BF6 CASEID 460 5 2 has 3 U5s coded 0). If I'm looking at this correctly, do you have any guidance on how to manage the issue?
Child File No. of Obs. with V137 Coded "0"
BF6 339
BJ6 372
CI6 304
CM6 622
GH5 107
GN6 239
NI6 205
SL5 293
SN6 209

Re: No. of U5 in HH coded "0" ?. [message #22169 is a reply to message #22143] Tue, 09 February 2021 07:21 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3061
Registered: February 2013
Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

I followed up on the woman in BF6. She had three children in the past five years (v208=3) but they all died before the date of the survey. The Stata lines that are copied below show this.

You could confirm this just within the IR file. For example, for the youngest child, b5_01 (in the IR file) is 0, indicating that the youngest child had died. If this child had b5_01=1, that is, had survived, you would look at b9_01, which is 0 if the child is alive and living with the mother. If b9_01 was some other numeric value, the child would be alive and not with the mother. I suspect your other examples will also show that the children have died or, if alive, are not living with the mother. DHS does many consistency checks with these variables.

use ...BFIR62FL.DTA" , clear
list v201 v208 v137 if v001==460 & v002==5 & v003==2
* This woman has had three births in the past five years

use ...BFPR62FL.DTA" , clear
list hv001 hv002 hvidx hv101-hv105 if hv001==460 & hv002==5
* No children under five living in the household

use ...BFBR62FL.DTA" , clear
list v201 v208 v137 bidx b5 b9 if v001==460 & v002==5 & v003==2 b9*
* All three children died
Previous Topic: Basic Vaccination and Nutritional Status STATA HELP
Next Topic: Children's age in months
Goto Forum:

Current Time: Sat May 18 18:42:39 Coordinated Universal Time 2024