The DHS Program User Forum: Weighting data » Weighting after pooling multiple countries

Home » Data » Weighting data » Weighting after pooling multiple countries

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

Weighting after pooling multiple countries [message #24633]

Fri, 10 June 2022 10:21

dgodha
Messages: 44
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

[Message index]

		Weighting after pooling multiple countries By: dgodha on Fri, 10 June 2022 10:21
		Re: Weighting after pooling multiple countries By: Janet-DHS on Wed, 15 June 2022 09:03
		Re: Weighting after pooling multiple countries By: dgodha on Thu, 16 June 2022 08:55

Previous Topic:	create a weighted population variable
Next Topic:	Weight to use for regression that has children and mother level variables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Apr 26 14:23:28 Coordinated Universal Time 2024