The DHS Program User Forum: Merging data files » mv001, mv002 and mv034

Home » Data » Merging data files » mv001, mv002 and mv034_1 do not uniquely identify observations

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

mv001, mv002 and mv034_1 do not uniquely identify observations [message #2479]

Fri, 27 June 2014 07:00

Abisiku
Messages: 8
Registered: June 2014
Location: Lusaka

Member

Dear All.

I am trying to merge male and female data for Zambia to create a couple file. Following the DHS documentation on merging, I've renamed the variables v001,v002 and v034 to mv001,mv002 and mv034_1, and sorted them on both. When I want to merge 1:1, Stata gives message that mv001, mv002 and mv034_1 do not uniquely identify observations in the master data. I am not sure where i have gone wrong.

Your assistance on this will be greatly appreciated.

ENSI

[Updated on: Fri, 27 June 2014 07:32]

Report message to a moderator

Re: mv001, mv002 and mv034_1 do not uniquely identify observations [message #2480 is a reply to message #2479]

Fri, 27 June 2014 08:53

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

We already have the couples file created, and you can download that from your account: ZMCR*.ZIP.
This dataset has one record for every couple. It contains data for married or living together men and woman who both declared to be married (living together) to each other and with completed individual interviews (questionnaires). Essentially the file is the result of linking the male recode and the female recode data files, based on whom they both declared as partners. The unit of analysis (case) in this file is the couple.

Also, there are several discussions on the forum, re merging DHS datasets see the following link:

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

Report message to a moderator

Re: mv001, mv002 and mv034_1 do not uniquely identify observations [message #2481 is a reply to message #2480]

Fri, 27 June 2014 10:26

Abisiku
Messages: 8
Registered: June 2014
Location: Lusaka

Member

Thank you very much. The last time i looked at the couple data i was not sure if i could use it to do the analysis i wanted but after reading your mail i went back to the couple recode and managed to do it.

ENSI

[Updated on: Fri, 27 June 2014 10:27]

Report message to a moderator

Re: mv001, mv002 and mv034_1 do not uniquely identify observations [message #2482 is a reply to message #2481]

Fri, 27 June 2014 10:34

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

You're welcome.

Bridgette

Report message to a moderator

Previous Topic:	SPSS - Merging Household variables with Individual Women's dataset
Next Topic:	Male Recode and HH Member Recode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 3 23:43:15 Coordinated Universal Time 2025