The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Nepal » Identifying migrants & merging with PR file
Identifying migrants & merging with PR file [message #15759] Tue, 11 September 2018 04:48
csap
Messages: 1
Registered: September 2018
Member
Dear All,

I am using Nepal DHS 2006 dataset. I would like to identify the migrants and then merge it with the PR file. Eventually, my goal is to identify individuals whose spouses have migrated. The unit of analysis is individual (not household).

I did the following:

1. Using the HR file I reshaped the data in long format and created variables related to in and out migration along with hvidx (hvidx_*) and migrant line number (sh25_* ).

2. I sorted it: hv001 hv002 hvdix

3. I merged it 1:1 with the PR file (which of course is sorted like #2).

It merged but I got very strange results. For instance, in the merged dataset, hv001 hv002 hvidx [101 3 1] individual is male and 72 years old. But in the HR file (after reshape or before it), it shows male but lower year of age. Apparently, these two individuals appear different if my reshape and merge are correct. Is it?

Can anyone help/suggest me how to successfully identify the migrants and then merge it with PR file?

Thank you!
Previous Topic: dhs nepal 2016 individual recode documentation
Next Topic: CMC codes
Goto Forum:
  


Current Time: Fri Nov 16 20:16:38 Eastern Standard Time 2018