| Malaria (by microscopy) in Lagos State [message #27260] | 
			Sat, 08 July 2023 20:31   | 
		 
		
			
				
				
				
					
						  
						cleonard
						 Messages: 3 Registered: November 2017 
						
					 | 
					Member  | 
					 | 
		 
		 
	 | 
 
	
		Hello,  
 
I am calculating the weighted number of children 6- 59 months tested for malaria by microscopy and the number of children positive for malaria by microscopy. The dataset I am using is NGPR81FL. I am using the exact guidelines as shown in the DHS Guide to Statistics: 
 Number of de facto children tested using microscopy (hv042 = 1 & hv103 = 1 & hc1 in 6:59 & hml32 in 0,1,6) 
 Number of de facto children tested using microscopy who are positive for malaria (hml32 = 1) 
 
I am also taking into account the complex sample design which include strata, cluster and weights. I am coding in R and have attached my code sample to this post. 
 
I am comparing my results with the 2021 Nigeria MIS Report, specifically pg. 147 (Table B.46), which does not match up. I am getting 205 for weighted number of children tested by microscopy, and 2 children who tested positive.  
 
Has anyone else had the issue? I wonder if something is wrong with my code. Thank you very much. 
		
		
  Colleen
		
 |  
	| 
		
	 | 
 
 
 |