The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Male Recode and HH Member Recode
Male Recode and HH Member Recode [message #2497] Mon, 30 June 2014 13:44 Go to next message
sarsons is currently offline  sarsons
Messages: 2
Registered: June 2014
Location: United States
Member
Hi everyone,

I am trying to merge the male recode and household member files. I am sorting and merging on cluster (mv001/hv001) and household number (mv002/hv002). The cluster number for the male recode i only 1 digit while it is 4 digits in the household member dataset. I thought that the household cluster number was 1000+mv001, but it doesn't look like that's the case. Can anyone shed some light on how to merge these two files?

Thanks!
Re: Male Recode and HH Member Recode [message #2498 is a reply to message #2497] Mon, 30 June 2014 13:55 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1763
Registered: February 2013
Senior Member
Looks like you are missing the line number. There are several discussions on the user forum re merging DHS datasets. Please see one such discussion at:

http://userforum.dhsprogram.com/index.php?t=msg&th=1342& amp; amp;goto=2365&S=8121847911c49a4f9fd2a7730e60aaa3#msg_236 5

[Updated on: Mon, 30 June 2014 13:57]

Report message to a moderator

Re: Male Recode and HH Member Recode [message #2499 is a reply to message #2498] Mon, 30 June 2014 13:59 Go to previous messageGo to next message
sarsons is currently offline  sarsons
Messages: 2
Registered: June 2014
Location: United States
Member
Hi Bridgette,

Thanks so much for your quick response! I am merging on the variables listed in the table you linked to but the problem is that mv001 and hv001 don't actually match up. one of them is 4 digits while the other is 1 and I can't find a reference explaining what is going on there. Any thoughts?

Thanks again
Re: Male Recode and HH Member Recode [message #2500 is a reply to message #2499] Mon, 30 June 2014 14:28 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1763
Registered: February 2013
Senior Member
I checked NGMR52FL.SAV & NGPR52FL.SAV - and in both data files, cluster (MV001/HV001) is 8 digits. You should be able to the merge without any problems.

Thanks,

Bridgette
Previous Topic: mv001, mv002 and mv034_1 do not uniquely identify observations
Next Topic: variables hv001 hv002 hv003 do not uniquely identify observations in the using data
Goto Forum:
  


Current Time: Sat Mar 28 20:31:46 Eastern Daylight Time 2020