The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging and Weighting PR and KR
Merging and Weighting PR and KR [message #14228] Wed, 07 March 2018 10:01 Go to next message
hkj3 is currently offline  hkj3
Messages: 5
Registered: February 2018
Location: London

I would like to merge PR and KR files for Malawi 2015/16 data.

As there is more information on child health via KR.

I have tried following the instructions via

Firstly I sorted the HV001 AND HV002 to make them key variables. But via SPSS it keeps saying that " Warnings
Duplicate key in a table lookup (dimension) file. Cases (records) must be uniquely identified in the table lookup file based on key value(s) specified with the ON keyword.
Execution of this command stops."

Secondly should I weight the data prior to merger or after ?

Thank you for your time.

Re: Merging and Weighting PR and KR [message #14229 is a reply to message #14228] Wed, 07 March 2018 10:12 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1621
Registered: February 2013
Senior Member
Please search the forum - there are multiple posts on merging data. You do not have to weight the data before merging.

[Updated on: Wed, 07 March 2018 10:12]

Report message to a moderator

Re: Merging and Weighting PR and KR [message #14262 is a reply to message #14228] Wed, 14 March 2018 15:33 Go to previous message
boyle014 is currently offline  boyle014
Messages: 59
Registered: December 2015
Location: Minneapolis
Senior Member
Hi hkj3,

Not clear what type of analysis you want to conduct. If you simply want to attach household characteristics to the children, you might want to try IPUMS DHS. Select children as your unit of analysis. Then select the Malawi 2016 sample. You will find that most of the household variables are available. You can log in using your regular DHS username (email) and password.

Professor Elizabeth Boyle
Sociology & Law, University of Minnesota, USA
Principal Investigator, IPUMS-DHS
Previous Topic: Merging Child and Household Data
Next Topic: creating panel of EAs?
Goto Forum:

Current Time: Fri May 24 01:57:45 Eastern Daylight Time 2019