The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » Multiple Sexual Partner in Husband
Multiple Sexual Partner in Husband [message #24218] Fri, 18 March 2022 07:00 Go to previous message
Nike2021 is currently offline  Nike2021
Messages: 8
Registered: October 2021
Member
I am using the variable v836 "Total lifetime number of sexual partners" of women as one of the risk factors for cervical cancer. I also want to include history of multiple sexual partners in the woman's husband. I saw 'mv836' in the men's recode. I am using R statitical software for my analysis. And I am looking at the survey of 8 West African countries 2017-2020 (Benin 2017-2018, Cameroon 2018, Gambia 2019/2020, Guinea 2018, Liberia 2019/2020, Mali 2018, Nigeria 2018, and Sierra Leone 2019).
I merged the women and men dataset by:
1. selecting the need variables from the two dataset
2. Adding a matching variable to both data frame
3. Merge the men and women data
4. Specify the survey design

I noticed that the total from the merged data is lower than the original total of the women data. E.g. in Benin the total number of women surveyed is 15928; after I merged it with the men data it became 10294. It means some of the records cannot be merged. What do you suggest please?

[Updated on: Tue, 22 March 2022 05:43]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Extracting data from HH
Next Topic: Education in single years
Goto Forum:
  


Current Time: Tue Aug 16 12:19:55 Coordinated Universal Time 2022