The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » mv001, mv002 and mv034_1 do not uniquely identify observations
mv001, mv002 and mv034_1 do not uniquely identify observations [message #2479] Fri, 27 June 2014 07:00 Go to next message
Abisiku is currently offline  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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
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



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 Go to previous messageGo to next message
Abisiku is currently offline  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 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member
You're welcome.

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


Current Time: Thu Mar 28 11:42:38 Coordinated Universal Time 2024