Merging Nepal DHS data sets across years [message #2995] |
Wed, 01 October 2014 18:52  |
UAB_user
Messages: 21 Registered: September 2014 Location: Alabama
|
Member |
|
|
Hello,
For my current project I am merging all the Nepal DHS files (Household, (individual)Women, (individual)Men, Children, Births, Household member) for the years 1996, 2001, 2006, 2011. I know you have to merge all of the files within a year before you can concatenate each of the years together. However, I have noticed that several variables have the same name within the Nepal DHS files (Household, (individual)Women, (individual)Men, Children, Births, Household member) and some variables which measure the same thing are named differently in separate DHS files. I have also noticed that some of the variables change their names over the years.
Is there a way to merge all of the files together across different years or do I have to choose the variables I need before I merge the data sets together and limit the number of variables in my final dataset.
Thank you
Derek
|
|
|