The DHS Program User Forum: Weighting data » Weight about pooling 2003,2008,2013,2018 BR dataset in Nigeria

Home » Data » Weighting data » Weight about pooling 2003,2008,2013,2018 BR dataset in Nigeria (How to weight pooling dataset)

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

Weight about pooling 2003,2008,2013,2018 BR dataset in Nigeria [message #18938]

Sat, 21 March 2020 18:43

geass
Messages: 4
Registered: June 2018

Member

I did the following de-normalization.
In 2003,2008,2013,2018 BR data,according to"Note on DHS standard weight de-normalization"
V005*=V005×(total females age 15-49 in the country at the time of the survey)/(number of women age 15-49 interviewed in the survey)
For example, in 2018 BR dataset, I did
gen wgt=v005/1000000
gen wgt_new=(wgt*44911147)/41821
gen survey=1
egen clusterid=group(survey dhsclust)
egen stratumid=group(survey v023)

I did the same progress in 2013,2008,2003.
Then I pooled four rounds into one dataset.
I use the pooling data to do regression.
reg Y X [pw=wgt_new]

My question:
(1) Is the above weighting and pooling data right?
(2) When I do the regression, do I need to do "reg Y X [pw=wgt_new]" , OR just do "reg Y X" without "[pw=wgt_new]"

Thank you very much
I hope to receive your reply.

Report message to a moderator

[Message index]

		Weight about pooling 2003,2008,2013,2018 BR dataset in Nigeria By: geass on Sat, 21 March 2020 18:43
		Re: Weight about pooling 2003,2008,2013,2018 BR dataset in Nigeria By: Bridgette-DHS on Mon, 30 March 2020 15:54
		Re: Weight about pooling 2003,2008,2013,2018 BR dataset in Nigeria By: geass on Mon, 30 March 2020 19:52
		Re: Weight about pooling 2003,2008,2013,2018 BR dataset in Nigeria By: geass on Wed, 01 April 2020 01:13
		Re: Weight about pooling 2003,2008,2013,2018 BR dataset in Nigeria By: Bridgette-DHS on Wed, 03 June 2020 16:52

Previous Topic:	Sample weights and stratification - Nigeria 2008 and 2018
Next Topic:	Weighted result's total gives different total value with unweighted one.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Nov 23 05:32:10 Coordinated Universal Time 2024