The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Nepal » Merging Nepal DHS data sets across years
Re: Merging Nepal DHS data sets across years [message #3019 is a reply to message #2995] Fri, 03 October 2014 23:58 Go to previous messageGo to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 802
Registered: January 2013
Senior Member
Hi Derek,

I think you are adding some extra complexity that you don't need. The household members (PR) dataset already includes the household variables, so there is no need to merge those. Similarly, merging the birth history data and the women's data is unnecessary as the birth history data has the women's data included.

You say that you want the unit of analysis to be the individual women. In that case you should start with the IR file and the merge the PR file to it. That will give you all of the variables you need with women as the unit of analysis. You can do this using the following variables:
v001 = hv001
v002 = hv002
v003 = hvidx

Each of the surveys has different variables included in the datasets, so you will probably have to restrict the variables to a common set. Additionally you will need to check that all of the variables you select are coded in the consistent manner across years.

You also need to look at how to pool data across years. I suggest starting by looking at the following thread: http://userforum.dhsprogram.com/index.php?t=msg&th=1189& amp;goto=2028&S=e803cfb9483c4984bc8aaa934d882b45#msg_202 8

Finally, why do you want to use a pooled dataset?

 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Merging data sets for DHS 2011 for Nepal
Next Topic: Migration destination in 2006 DHS
Goto Forum:
  


Current Time: Sat Oct 19 18:21:58 Coordinated Universal Time 2024