The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Appending Multi-phase Nigerian DHS Surveys (Handling Inconsistent Value Labels and Creating a Survey Design for Multi-phase DHS Surveys)
Re: Appending Multi-phase Nigerian DHS Surveys [message #30134 is a reply to message #29965] Tue, 01 October 2024 16:11 Go to previous messageGo to previous message
Oby is currently offline  Oby
Messages: 6
Registered: August 2024
Member
Thank you for your response bridgette. I have a follow-up question. My analytic sample is currently married women(15-49 years) and according to DHS guidelines, I am to denormalise the weight using population data from UNPD World Population Prospects. However, there is no population data for currently married women in Nigeria. Since I don't have direct population data for currently married women in Nigeria, I plan to use the proportion of currently married women from the DHS data to estimate it, and then apply that proportion to the total population of women aged 15-49 for each survey year.

This is my code below (I am using R)
# Denormalising the weight using population data from UNPD World Population Prospects-----

# divide v005 by 1 million
ir_2003 <- ir_2003 %>% mutate(weight_norm = v005 / 1000000)
ir_2008 <- ir_2008 %>% mutate(weight_norm = v005 / 1000000)
ir_2013 <- ir_2013 %>% mutate(weight_norm = v005 / 1000000)
ir_2018 <- ir_2018 %>% mutate(weight_norm = v005 / 1000000)

# total population of 15-49 women for each survey year
pop_2003 <- 31544644
pop_2008 <- 35882027
pop_2013 <- 41018918
pop_2018 <- 47146390

# Estimate the population of currently married women for each survey year
pop_married_2003 <- pop_2003 * prop_married_2003 # (prop_married means proportion of currently married)
pop_married_2008 <- pop_2008 * prop_married_2008
pop_married_2013 <- pop_2013 * prop_married_2013
pop_married_2018 <- pop_2018 * prop_married_2018

# Denormalize the weights using the estimated population of currently married women
ir_2003 <- ir_2003 %>% mutate(weight_denom = weight_norm * pop_married_2003 / sum(weight_norm))
ir_2008 <- ir_2008 %>% mutate(weight_denom = weight_norm * pop_married_2008 / sum(weight_norm))
ir_2013 <- ir_2013 %>% mutate(weight_denom = weight_norm * pop_married_2013 / sum(weight_norm))
ir_2018 <- ir_2018 %>% mutate(weight_denom = weight_norm * pop_married_2018 / sum(weight_norm))

Would this be accurate, or should I just use the data for the total population of women without applying the proportion?

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Merging data files
Next Topic: Merging IR MR file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Wed Oct 14 18:52:00 Eastern Daylight Time 2026
.:: Contact :: Home :: Privacy Policy ::.

Powered by: FUDforum 3.0.9.
Copyright ©2001-2018 FUDforum Bulletin Board Software