Merging BR and WI in the Egypt 2000 survey [message #8870] |
Thu, 07 January 2016 11:25 |
yanesko
Messages: 1 Registered: January 2016
|
Member |
|
|
Dear DHS,
When I try to merge the BR and WI files in the Egypt_2000 survey, I get 0 matches. I was wondering if the WI file is actually not from this survey (since the number of the Phase in the file name is different)?
Here is the STATA code I use:
use EGBR42FL.DTA
gen whhid = substr(caseid, 1, 12)
merge m:1 whhid using EGWI41FL.DTA, keepusing(wlthind5) keep(match master)
I used the same code for other surveys and it worked fine.
Thank you in advance!
Yana
|
|
|