The DHS Program User Forum: Merging data files » Merging Hiv Women Men and Couples

Home » Data » Merging data files » Merging Hiv Women Men and Couples

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

Merging Hiv Women Men and Couples [message #4165]

Sat, 11 April 2015 07:01

Micaela_A
Messages: 1
Registered: April 2015
Location: Italia

Member

Hello, I'm writing a paper on the impact of gender roles on the diffusion of HIV in Lesotho. I merged the hiv dataset with the IR and MR separately and then wanted to merge these two datasets to only have the couples. I know a Couples' Recode is already available but I was wondering which keys you use to know that person 1 is the partner of person 2. Because I merged the datasets and while most of the information that I got in the process was plausible, I also got that 150 couples or so had a big difference of 'age of respondent' and 'age of partner' answered by the other member of the couple. Is it believable that a couple has a 61 years of difference in actual age and age known by the partner? I checked this information on the CR and I got the same information regarding this and other individuals with less(though still big) difference...

[Updated on: Wed, 15 April 2015 17:26]

Report message to a moderator

Re: Merging Hiv Women Men and Couples [message #4282 is a reply to message #4165]

Thu, 30 April 2015 13:02

Trevor-DHS
Messages: 802
Registered: January 2013

Senior Member

The key variables to use are:
Women: V001 (cluster number) V002 (household number) V034 (line number of husband)
Men: MV001 (cluster number) MV002 (household number) MV003 (line number of man)

See http://www.dhsprogram.com/data/Merging-Datasets.cfm for more info.

Report message to a moderator

Previous Topic:	merging height weight file to children's file in SPSS
Next Topic:	How to merge women and child data set?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 7 16:42:33 Coordinated Universal Time 2024