The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Lesotho (2014) Couples & HIV: Matching Number of Cases
Lesotho (2014) Couples & HIV: Matching Number of Cases [message #12954] Sat, 19 August 2017 13:24 Go to next message
CMonkey42 is currently offline  CMonkey42
Messages: 2
Registered: August 2017

(Lesotho 2014)

I've merged couples and HIV test recode in SPSS, and have created a new variable to define couples' HIV status.

When cross-tabbing this new variable with women's HIV test results, my n=708 the same as the official report.

When cross-tabbing with men's HIV test results, my n=722.

Can anyone help explain why this might be? Why when cross-tabbing with men do I get an extra 14 cases?

I think it might be because some men are counted in more than one couple. Attached is a record of the number of other wives; and for men with 2 or more wives, and for those that responded "don't know", counts to 14. If this is the reason, how can I drop the these 14 cases using syntax, or do people know a better way to deal with this situation?

If anyone has any advice please, please, please let me know! It will be extremely appreciated, thank you!

[Updated on: Thu, 24 August 2017 18:36]

Report message to a moderator

Re: Lesotho (2014) Couples & HIV: Matching Number of Cases [message #13108 is a reply to message #12954] Thu, 21 September 2017 13:45 Go to previous message
dnbhatta is currently offline  dnbhatta
Messages: 9
Registered: September 2017
Location: Nepal
Do you have any idea how to merge male dataset and female dataset to make a couple dataset. I could not understand the value in V034 and MV034$1, those are too different, where female dataset has value 1 is more common and male dataset has vale 2 more common and there are other different values, so how could we match the the couple based on these values. How do we know which is the couple (1 female and 1 male is couple or 1 female and 2 male is couple).
If you have any command in Stata or R or other software, please share it, my e-mail:

Previous Topic: Linking GPS data to DHS data files
Next Topic: Merging Zambia LCMS and DHS
Goto Forum:

Current Time: Fri Mar 22 00:58:27 Eastern Daylight Time 2019