| Merging KR and BR data files  [message #19180] | 
			Tue, 05 May 2020 16:25   | 
		 
		
			
				
				
				
					
						  
						ask_ans_sri
						 Messages: 2 Registered: June 2018  Location: DELHI
						
					 | 
					Member  | 
					 | 
		 
		 
	 | 
 
	
		I have tried to replicate table no. 10.12 in NFHS-4, India report. For this I have merged KR and PR by following syntax  
 
use kr.dta  
 
rename caseid hhid  
rename (v000 v001 v002 v003)(hv001 hv002 hv003) 
rename b16  
drop if b16 ==. | b16==0  
 
save kr.dta  
 
 
use pr.dta  
 
merge m:m using hv001 hv002 hv003 hvidx using kr.dta  
 
save krpr.dta  
 
I am unable to match frequencies with the reported frequency on table 10.12. Even though I got same percentage with KR file, but unable to match frequencies. Please do help me.  
 
I have used all the weights and filtered hv103 ==1 and hv102==1. But still not able to match. Please help me.       
		
		
		
 |  
	| 
		
	 | 
 
 
 |