The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » What is the underlying criteria for merging datasets from various waves?
What is the underlying criteria for merging datasets from various waves? [message #9968] Thu, 09 June 2016 08:47 Go to previous message
sufi is currently offline  sufi
Messages: 3
Registered: June 2016
Member
Hello all,

I'm working on a large piece of data which contains virtually all African datasets in the DHS.
I'm having some trouble figuring out the exact criteria for merging individual recode files with male recode, hiv, and GPS files.
I fully understand that matching individuals works at the cluster-householdno-personal number level. However, I'm unsure as to the criteria for merging files of the same country, in the same year.
Take Cameroon 2011 for example:
Would all files merge by cluster-householdno-personal number when using data from Cameroon 2011? The reason I'm unsure is because, for example, the hiv data is called CMAR61FL, while the male recode data is called CMMR60FL
One has the number '61' and the other has the number '60'. Should they still merge?

I would appreciate any help and clarification
Thanks in advance
 
Read Message
Read Message
Previous Topic: merging household and individual data
Next Topic: ID variables for Children
Goto Forum:
  


Current Time: Sun Apr 28 20:02:48 Coordinated Universal Time 2024