| Merging dataset for MIS 2015 Survery on stata [message #22020] | 
			Wed, 20 January 2021 09:49   | 
		 
		
			
				
				
				
					
						  
						toyosi
						 Messages: 3 Registered: January 2021 
						
					 | 
					Member  | 
					 | 
		 
		 
	 | 
 
	
		Hi I am using the 2015 MIS survey for my dissertation however I having trouble merging the household dataset which is KEPR7ADT with the womens/individual dataset which is KEIR7A on STATA. Please can anyone let me know what to do , i have tried using the guidance provided on the dhs website but it did not work.  
this is the code i used: 
 
use "/Users/t/Desktop/Actual dataset/PR2.DTA" 
 
rename hv001 v001 
rename hv002 v002 
sort v001 v002 
save "/Users/Desktop/Actual dataset/PR2.DTA", replace 
 
use "/Users/t/Desktop/Actual dataset/IR.DTA" 
sort v001 v002 
 
merge m:1 v001 v002 using PR2 
 
I received the error message that the variables v001 v002 do not uniquely identify observations in the using data  
 
I dont know what i did wrong as this is what the dhs guide says to do . Pls help  
 
thank you so much,  
 
toyosi
		
		
		[Updated on: Wed, 20 January 2021 09:58] Report message to a moderator  
 |  
	| 
		
	 | 
 
 
 |