The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » merging household and husbands' info to women
merging household and husbands' info to women [message #3976] Fri, 13 March 2015 05:58 Go to previous message
Ogriv is currently offline  Ogriv
Messages: 16
Registered: March 2015
Member
Hello there
I am a new DHS user, and am currently working with Kenya 2010.

I would like to primarily use the women's files, but also need further relevant information from both the household file and some elements regarding the socioeconomic status of their husbands if they have one.

I have already done a successful merge between the women's and the household file, so that each woman in the individual recode has household information assigned.

Next I'm trying to attach husbands' information using the couples' file.

In Stata I sorted on strata, cluster, household and line number of husband in my newly merged women's/household file.

v022 v001 v002 v034 to be precise.

I sorted on the same in the couples' file.

Then I tried a one to one merge on the same variables with the couples file as the master file.

I'm getting the error message: "variables v022 v001 v002 v034 do not uniquely identify observations in the master data"

Do I need to add a country-specific identifier (and if so, which?), or is there a more fundamental problem?

Thanks
S.

[Updated on: Fri, 13 March 2015 10:15]

Report message to a moderator

 
Read Message
Read Message
Read Message
Previous Topic: merging IR and HIV
Next Topic: Mergining PR onto a Combined IR, MR Dataset in SPSS
Goto Forum:
  


Current Time: Fri Mar 29 09:09:00 Coordinated Universal Time 2024