| 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: 3230 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 
		
		
		
 |  
	| 
		
	 | 
 
 
 |