The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging DHS data in Stata
Re: Merging DHS data in Stata [message #8347 is a reply to message #2496] Wed, 14 October 2015 09:38 Go to previous messageGo to previous message
kinsukmanisinha@gmail.com
Messages: 9
Registered: January 2015
Location: Milan
Member
Dear DHS experts,

I am trying to merge the IR and PR file. I have read the comments on this page, about how to use m:m merge (question by
owraza and reply by DHS expert). I understand the entire procedure (use hv001 & hv002 from PR and v001
v002 from IR) but towards the beginning of the explanation the DHS expert mention that is is better to perform old merge as the new m:m merge may do something we dont want it to.

I have stata verion 12 and it does not allow me to use old merge, leaving m:m merge as the only option. However, the help file on stata suggest that I may use joinby, can I do this..???

So, if I use joinby

In the PR (household file):
rename hv001 v001
rename hv002 v002
sort v001 v002

In the IR (women file):
sort v001 v002

I am lost after this point, I cant use m:m merge as that is not advised and I dont know how to proceed further. I would appreciate any help.

Thanks a lot.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to match women to their husbands
Next Topic: Merging HR and PR Files
Goto Forum:
  


Current Time: Wed Dec 25 10:26:24 Coordinated Universal Time 2024