The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Weighting after pooling multiple countries
Weighting after pooling multiple countries [message #24633] Fri, 10 June 2022 10:21 Go to previous message
dgodha
Messages: 43
Registered: November 2016
Location: India
Member
Hello DHS Experts,

Thanks to you and this forum, I have learnt a lot on pooling and weighting.

My current focus on pooling is to gain insight into stunting and neonatal mortality across Sub-Saharan Africa. I have pooled 19 countries but I don't want one country to dominate the results. I plan to do logistic regression instead of multi-level modelling.

Accordingly, I have given equal weight to each survey (before pooling) using the following commands:
scalar TOTWT=1000000
quietly summarize v005
scalar T=r(sum)
gen v005r=v005*TOTWT/T
In addition, I have modified the stratum and psu variables as follows:
gen cluster_id=survey*1000+v021 
gen stratum_id=survey*1000+v023
Now, I am not sure if I have surveyset correctly- do I still need to divide my weight variable by 1000000? My code is as follows:
gen wt=v005r/1000000
svyset cluster_id [pweight=wt], strata(stratum_id) vce(linearized) singleunit(centered) 
I will appreciate your guidance on this.
Many thanks


Deepali

[Updated on: Fri, 10 June 2022 10:22]

Report message to a moderator

 
Read Message
Read Message
Read Message
Previous Topic: Weigthing and pooling multicountry datasets
Next Topic: Weight to use for regression that has children and mother level variables
Goto Forum:
  


Current Time: Tue Aug 16 01:16:29 Coordinated Universal Time 2022