clear all

*Renaming Household's unique variable*

use "C:\Users\...\PKPR61FL.DTA" 
gen v001=hv001
gen v002=hv002
label variable v001 "Cluster number_copy"
recast long v001
format %12.0g v001
label variable v002 "Household number_copy"
recast int v002
format %8.0g v002 

sort v001 v002
save "C:\Users\...\PKPR61FL_A.DTA"

*Merging Women's file with Household's file*

use "C:\Users\...\PKIR61FL.DTA", clear
sort v001 v002
merge m:m v001 v002 using "C:\Users\...\PKPR61FL_A.DTA"

* For checking merging has done correctly *
* v138=eligible women in women's questionnaire & hv010=eligible women in household's questionnaire*
tab v138 hv010