The DHS Program User Forum: Merging data files » Male Recode and HH Member Recode

Home » Data » Merging data files » Male Recode and HH Member Recode

Show: Today's Messages :: Show Polls :: Message Navigator

Male Recode and HH Member Recode [message #2497]

Mon, 30 June 2014 13:44

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!

Report message to a moderator

Re: Male Recode and HH Member Recode [message #2498 is a reply to message #2497]

Mon, 30 June 2014 13:55

Bridgette-DHS
Messages: 3203
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

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

Report message to a moderator

Re: Male Recode and HH Member Recode [message #2500 is a reply to message #2499]

Mon, 30 June 2014 14:28

Bridgette-DHS
Messages: 3203
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Dec 3 11:28:19 Coordinated Universal Time 2024