The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging Children with Household
Re: Merging Children with Household [message #9376 is a reply to message #9348] Tue, 22 March 2016 09:48 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3214
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:


The following should work (I have shortened your filenames):

use PEPR6IFL.DTA, clear
rename hv001 v001
rename hv002 v002
rename hvidx b16
sort v001 v002 b16
save PEPR6IFLTEMP1.DTA, replace

use PEKR6IFL.DTA, clear
sort v001 v002 b16
merge 1:1 v001 v002 b16 using PEPR6IFLTEMP1.DTA

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Merging Birth and Household Recodes
Next Topic: Dropping cases with HIV05 missing in SPSS
Goto Forum:
  


Current Time: Sun Dec 22 06:17:49 Coordinated Universal Time 2024