The DHS Program User Forum: Weighting data

Home » Data » Weighting data » Pooled Cross sections

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

Re: Pooled Cross sections [message #10084 is a reply to message #10080]

Thu, 23 June 2016 15:18

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from DHS Stata Specialist, Shireen Assaf:

When you compute the NW the magnitude of the weight is increased by a factor of 1000 because of the CSW. It seems you need to divide the NW by 1000, i.e.:

gen NW2=NW/1000
tab ADM1_CODE [iw=NW2]

If you use svy with pweights the percentage estimates would not be affected by using NW or NW2 just the frequencies. So if you just report the percentages this shouldn't matter and no need to divide the NW by 1000, just use svy and pweights.

I would also suggest not using NW and simply use the weights for the appended data as follows.

gen wt= v005/1000000

egen strata=group(v000 v025 ADM1_CODE) // strata also includes the survey (identified by v000) in the group command

egen v001r = group(v000 v001) // cluster also includes the survey in the group command

svyset v001r [pw=wt], strata(strata) singleunit(centered)
svy: tab ADM1_CODE

You will notice that the percentages are quite close to those produced when using svy and NW or NW2.

svyset v001r [pw=NW], strata(strata) singleunit(centered)
svy: tab ADM1_CODE

Report message to a moderator

[Message index]

		Pooled Cross sections By: cbdolan on Tue, 14 June 2016 09:35
		Re: Pooled Cross sections By: Reduced-For(u)m on Wed, 15 June 2016 15:48
		Re: Pooled Cross sections By: cbdolan on Thu, 23 June 2016 10:22
		Re: Pooled Cross sections By: Bridgette-DHS on Thu, 23 June 2016 15:18
		Re: Pooled Cross sections By: cbdolan on Fri, 24 June 2016 09:33
		Re: Pooled Cross sections By: Bridgette-DHS on Thu, 30 June 2016 09:46
		Re: Pooled Cross sections By: CKAllen on Fri, 26 August 2016 10:28
		Re: Pooled Cross sections By: Bridgette-DHS on Mon, 29 August 2016 10:05
		Re: Pooled Cross sections By: id709nvz on Tue, 06 October 2020 21:45
		Re: Pooled Cross sections By: Bridgette-DHS on Fri, 09 October 2020 11:57
		Re: Pooled Cross sections By: id709nvz on Fri, 09 October 2020 12:04
		Re: Pooled Cross sections By: joemer on Mon, 22 August 2016 02:56

Previous Topic:	Antenatal visit with skilled providers (Ethiopian DHS 2000, 2005, 2011 AND 2016))
Next Topic:	Using R to weight data for domestic violence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Sep 5 19:30:53 Coordinated Universal Time 2025