The DHS Program User Forum: Merging data files » Lesotho (2014) Couples & HIV: Matching Number of Cases

Home » Data » Merging data files » Lesotho (2014) Couples & HIV: Matching Number of Cases

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

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!

Attachment: Number of other wives.docx
(Size: 12.82KB, Downloaded 467 times)

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

Report message to a moderator

[Message index]

		Lesotho (2014) Couples & HIV: Matching Number of Cases By: CMonkey42 on Sat, 19 August 2017 13:24
		Re: Lesotho (2014) Couples & HIV: Matching Number of Cases By: dnbhatta on Thu, 21 September 2017 13:45

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Dec 22 10:57:03 Coordinated Universal Time 2024