| Lesotho (2014) Couples & HIV: Matching Number of Cases [message #12954] |
Sat, 19 August 2017 13:24  |
CMonkey42
Messages: 2
Registered: August 2017
|
Member |
|
|
Hello,
(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  |
dnbhatta
Messages: 9
Registered: September 2017
Location: Nepal
|
Member |
|
|
Hi
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: dnbhatta@yahoo.com
DNB
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
