The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging PR file with KR file
Merging PR file with KR file [message #2364] Mon, 09 June 2014 12:42 Go to next message
geoK is currently offline  geoK
Messages: 30
Registered: May 2014
Member
Hello! I am using Nigeria 2008 datasets and having trouble with finding the right variables to merge children (KR) and individual members (PR).
can anyone help please?
thanks
Re: Merging PR file with KR file [message #2365 is a reply to message #2364] Mon, 09 June 2014 13:29 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1621
Registered: February 2013
Senior Member
There are several discussions on the forum for merging DHS datasets. Please do a search on the Forum for "merge" or "merging". Following is a link for one such discussion.

http:// userforum.dhsprogram.com/index.php?t=msg&th=49&goto= 71&#msg_71

Also, please see the following table:

index.php?t=getfile&id=292&private=0
  • Attachment: capture.bmp
    (Size: 694.53KB, Downloaded 1547 times)
Re: Merging PR file with KR file [message #2369 is a reply to message #2365] Mon, 09 June 2014 15:39 Go to previous messageGo to next message
geoK is currently offline  geoK
Messages: 30
Registered: May 2014
Member
Thank you. I have done the merging several times but never between KR and PR, which I think is not covered in any other topic among the discussions, if I am not wrong. I am struggling this time in getting the variables (and cases) matching but I will try to follow the table you kindly sent and some other discussions. Thanks, Regards.
Re: Merging PR file with KR file [message #13753 is a reply to message #2369] Tue, 19 December 2017 11:13 Go to previous messageGo to next message
kanchanraj3 is currently offline  kanchanraj3
Messages: 1
Registered: December 2017
Location: Kathmandu
Member
Dear DHS Expert,
I am having merging the multiyear data? Do you suggest doing it? What is the ideal way of merging such data sets?


Kanchan
Re: Merging PR file with KR file [message #13769 is a reply to message #13753] Wed, 20 December 2017 16:45 Go to previous message
Reduced-For(u)m
Messages: 291
Registered: March 2013
Senior Member

Pooling multiple years is not a "merge", it is an "append". You just add the second round of data onto the first round of data.

There are a number of posts on the forum about dealing with weights and clustering when using multiple survey rounds, but there is no "merging" to be done, just "appending"... the DHS is not longitudinal, so there is no information to be linked from one survey round to the next in terms of merging variables. Another survey is just another set of observations from a different point in time.
Previous Topic: Merge CR and IR
Next Topic: merging HR and IR
Goto Forum:
  


Current Time: Fri May 24 01:56:40 Eastern Daylight Time 2019