The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Correct numbers for merging the household and individual files of the 2001 DHS Nepal
Correct numbers for merging the household and individual files of the 2001 DHS Nepal [message #3586] Tue, 13 January 2015 16:13 Go to next message
UAB_user is currently offline  UAB_user
Messages: 21
Registered: September 2014
Location: Alabama
Member
Hello,

Sorry for a double post, but I tried posting this in the "Nepal" section of the forum, but i noticed that several threads have gone unanswered since November and I got nervous my question would be forgotten....

I am looking at migration factors in Nepal I was wondering if I could check to make sure my merging is done correctly. I am using the Nepal DHS and I am merging the household and individual files of the 2001 DHS. There are 8602 observations in the 2001 household data and 8726 observations in the individual files. When I merge them together I get 10251 observations. Is this correct? I always thought there was a 1:1 merge for the individual and household files?

Thank you
Re: Correct numbers for merging the household and individual files of the 2001 DHS Nepal [message #3591 is a reply to message #3586] Wed, 14 January 2015 15:29 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1763
Registered: February 2013
Senior Member
When you merge the individual file with the household file, you should get as many observations as there are in the individual data file. Getting more means that you did not merge correctly.

Please search the forum for sample syntax on merging datasets.
Re: Correct numbers for merging the household and individual files of the 2001 DHS Nepal [message #3592 is a reply to message #3591] Wed, 14 January 2015 15:32 Go to previous messageGo to next message
UAB_user is currently offline  UAB_user
Messages: 21
Registered: September 2014
Location: Alabama
Member
Great! thank you!
Re: Correct numbers for merging the household and individual files of the 2001 DHS Nepal [message #3593 is a reply to message #3592] Wed, 14 January 2015 15:41 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1763
Registered: February 2013
Senior Member
You're welcome.
Previous Topic: how to merge data files from different countries
Next Topic: Height and Weight Files
Goto Forum:
  


Current Time: Sat Mar 28 20:33:18 Eastern Daylight Time 2020