No. of U5 in HH coded "0" ?. [message #22143] |
Sat, 06 February 2021 03:53 |
|
Hello,
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
thanks
jackyjoy
|
|
|
Re: No. of U5 in HH coded "0" ?. [message #22169 is a reply to message #22143] |
Tue, 09 February 2021 07:21 |
Bridgette-DHS
Messages: 3203 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
|
|
|