| Re: Merging data sets for DHS 2011 for Nepal [message #3036 is a reply to message #3035] |
Mon, 06 October 2014 13:18   |
pjoshi
Messages: 6
Registered: September 2014
|
Member |
|
|
Thanks so much for getting back to me. This information is definitely very helpful.
The main variable I need is a dummy variable at the individual level indicating whether a woman belongs to a household that has migrants working outside Nepal. So, my unit of analysis is women from IR file.
However, information on migration is only available in the household level data set (HR), so in this data set I categorized each household as migrant household or not by defining a new variable named var1.
Var1=1 if SH21==1 (i.e the household has a migrant member) and SH27_==1 (the member migrated to work) and SH28C>=2 (the member moved outside Nepal).
and var1=2 otherwise
Now, I want to add this variable (var1) to the individual data set, so I want to match women from each household with this new variable var1.
To merge the two data sets, I renamed hv001 and hv002 as v001 and v002 03 in the HR data set and used v001 and v002 as the identifying variables. I guess I didn't need hv003 for this purpose; thanks for correcting my mistake there.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
