Re: Merging Nepal DHS data sets across years [message #3018 is a reply to message #3005] |
Fri, 03 October 2014 18:23 |
UAB_user
Messages: 21 Registered: September 2014 Location: Alabama
|
Member |
|
|
Hello,
Thank you for helping me with my question. I would like my unit of observation to be the individual (women) and have their household's information attached to them. I will definitely be conscious of accidental double-counting and making sure my estimates are correct. However, I know merging the files correctly is an important step to getting the correct values and I just want to make sure I am doing it correctly.
Currently, for the 2011 files I am merging the "household" file to the "memberhousehold" file using the variables "hv001" and "hv002". Then I merge the "individual women" file using "v001" and "v002". Lastly, I merge the birth file using "v001, v002, v003".
I follow this merging order for the years 96', 01', 06', and 11'. I then concatenate them together into one data set.
Is there a template or set of instructions I can follow (other then what is on the DHS website) to make sure I am merging the files correctly? SAS or STATA code on how to merge the files would be a great help.
Thank you very much!
Derek
|
|
|