The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Nepal » Merging Household+Female+Male files
Re: Merging Household+Female+Male files [message #3834 is a reply to message #3575] Fri, 20 February 2015 20:01 Go to previous message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
Here is a response from one of our experts, Dr. Tom Pullum:
Quote:
I would use the following sequence, in Stata terminology (I do not use SAS). First, in the male file, rename the mv* variables to be v*. Then append one file to the other. This is not a merge, it is an append. Then rename v001 to be hv001, v002 to be hv002, and v003 to be hvidx. Then sort the combined file on hv001, hv002, hvidx. Save with a temporary file name such as "IR_MR_temp.dta". Then open the PR file, NOT the HR file, and sort it by hv001, hv002, hvidx. Then merge with "IR_MR_temp.dta". Then save cases that are in both files. Good luck!

 
Read Message
Read Message
Previous Topic: Migration destination in 2006 DHS
Next Topic: Correct numbers for merging the household and individual files of the 2001 DHS Nepal
Goto Forum:
  


Current Time: Tue Feb 25 20:54:47 Coordinated Universal Time 2025