The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Nigeria » Merging Children file to household file 2003 for Nigeria (Merging Children file to Household file)
Merging Children file to household file 2003 for Nigeria [message #15837] Tue, 25 September 2018 11:23 Go to next message
bamosbaminda1@sheffield.a is currently offline  bamosbaminda1@sheffield.a
Messages: 3
Registered: July 2018
Location: United Kingdom

Dear Forum members,
Please I am requesting for a guide to merge children file variable B5 to household file for DHS 2003 Nigeria.
I have attempted using ID HV001 and HV002 for household file with V001 and V002 for children file to merge. It has merged
the files but providing me more number of observations. Please can you advice me on how to go about merging the files.
Thank you.

[Updated on: Tue, 25 September 2018 11:29]

Report message to a moderator

Re: Merging ngpr to nghr [message #15838 is a reply to message #15837] Tue, 25 September 2018 11:33 Go to previous messageGo to next message
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
Please take a look at The Guide to DHS Statistics
The section on "Analyzing DHS Data" goes over merging.
Thank you!
Re: Merging ngpr to nghr [message #16081 is a reply to message #15838] Fri, 02 November 2018 09:13 Go to previous message
boyle014 is currently offline  boyle014
Messages: 78
Registered: December 2015
Location: Minneapolis
Senior Member
Note that in IPUMS DHS nearly all of the household variables are already attached to children, so there is no need for merging files.

Login using your DHS username (email) and password. Select Children as your unit of analysis; then select the sample (Nigeria 2003). Navigate to the child and household variables you want, and add them to your data cart by clicking the + sign next to them. To download your tailored data file, click on "View Data Cart" in the top right corner of the screen and follow the steps. (You'll probably want to click "Change" when you see the DATA FORMAT option, so that the data file matches your statistical software package.)

Professor Elizabeth Boyle
Sociology & Law, University of Minnesota, USA
Principal Investigator, IPUMS-DHS
Previous Topic: Nigeria DHS 1999
Next Topic: Maternal Health 2015
Goto Forum:

Current Time: Fri Dec 1 21:11:10 Coordinated Universal Time 2023