cd e:\DHS\DHS_data\scratch use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\RWPR81FL.DTA" , clear keep if hv117==1 keep hv0* hvidx hdis* gen cluster=hv001 gen hh=hv002 gen line=hvidx sort cluster hh line save RWPRtemp.dta, replace use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\RWIR81FL.DTA" , clear keep v0* d* gen cluster=v001 gen hh=v002 gen line=v003 sort cluster hh line merge 1:1 cluster hh line using RWPRtemp.dta keep if _merge==3 drop _merge
* Note: For the NT_MICRO sps file, you need to merge the KR with the HR file. * The merge will be performed before running any of the do files below. get file = datapath + "\"+ hrdata + ".sav" /rename (hv001=v001) (hv002=v002) /keep v001 v002 hv234a. save outfile = datapath + "\temp.sav". * open KR dataset. get file = datapath + "\"+ krdata + ".sav". match files /file=* /table= datapath + "\temp.sav" /by v001 v002.