The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Biomarkers » DHS survey design (which weighting variables to use in merged dataset KR+ PR? )
DHS survey design [message #24505] Wed, 25 May 2022 07:05 Go to previous message
Elisabetta is currently offline  Elisabetta
Messages: 2
Registered: April 2022
Member
Hello,
i have a problem with the analysis of weighted data. I´m currently working on my merged dataset KR+PR (my target is children under 5 years and i need variables from both datasets) using the following survey design:
kenya2020 %>% mutate(wt = V005/1000000)
DHSdesign <- svydesign(id = ~V021, strata = ~V023, weights = ~wt, nest = TRUE, data = kenya2020)

everything works until i want to generate predictors for malaria prevalence with the variables in PR: microscopy and RDT.
If I use only PR and the corresponding weight, strata and Id : HV005, HV021 and HV023 for generating the predictor I get percentages that match the report: micro : 3%, RDT = 4.5%
the problem is that i want to generate weighted frequency tables and run the svyglm function with my independent variables but I want to use the same target population I used for the other predictors (the merged dataset KR+PR) but if I use my merged dataset I run in a error because i have missing data for ID so i can only use the DHS design of KR (V005, V021, V023) to obtain weighted values for MICROSCOPY and RDT indicators. In this case I get values that are lower compared to those I get using the correct survey design (Because the merge takes into account less children (only those present in KR).

the question is,can I use the above mentioned survey design to assess malaria prevalence or do I need to find a different solution? In that case can you help me understand how ?

Thank you in advance.

Best regards,
Elisabett
 
Read Message
Read Message
Previous Topic: Vitamin D3
Next Topic: District names
Goto Forum:
  


Current Time: Tue Aug 16 15:47:47 Coordinated Universal Time 2022