The DHS Program User Forum - RDF feed
https://userforum.dhsprogram.com/index.php
Merging HW and BR in Zambia 2001-02
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=17792&th=8228#msg_17792
The code I used for merging waves II and III is as follows:
foreach i in 21 31 {
cd "$ZMHW"
use "ZMHW`i'FL", replace
ren hwcaseid caseid
ren hwline bidx
sort caseid bidx
cd "$cleandata"
save "ZMHW`i'FL_clean", replace
cd "$ZMBR"
merge 1:1 caseid bidx using "ZMBR`i'FL"
drop if hc70==.|hc70==9998
}