The DHS Program User Forum: Weighting data » Pooling 3 rounds of DHS Nepal -- weights?

Home » Data » Weighting data » Pooling 3 rounds of DHS Nepal -- weights? (pooled cross-section sampling weights Nepal)

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

Re: Pooling 3 rounds of DHS Nepal -- weights? [message #18252 is a reply to message #18185]

Mon, 21 October 2019 06:59

Bridgette-DHS
Messages: 3197
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

Say that you have combined the three surveys (by appending them) and you use v021 as the psu id and v023 and the stratum id. Then run these two lines:

egen clusterid=group(survey v021)
egen stratumid=group(survey v023)

This is the easiest way to get unique ids in the combined file for clusters and strata. There is no need to do any other kind of spatial reconciliation.

What you have done with the weights seems ok to me. Yes, the means will be 1 within each survey and overall. However, there is a problem of scale. You divided v005 by 1000000, but when you divide again by 2770.8256, etc. you will have a number which is much less than 1. You should avoid having decimal points or anything to the right of a decimal point in a weight. There are some kinds of weights (such as fweight in Stata) that require a weight to be an integer. I have encountered weighting procedures that will truncate a weight and ignore anything to the right of the decimal point, which means that a weight between 0 and 1 will be treated like 0--that is, the case will be ignored entirely! You might want to rescale your weights somehow with an arbitrary multiplier such as 1000000.

Report message to a moderator

[Message index]

		Pooling 3 rounds of DHS Nepal -- weights? By: LeahBevis on Tue, 08 October 2019 13:38
		Re: Pooling 3 rounds of DHS Nepal -- weights? By: Bridgette-DHS on Mon, 21 October 2019 06:59
		Re: Pooling 3 rounds of DHS Nepal -- weights? By: LeahBevis on Wed, 22 July 2020 15:46
		Re: Pooling 3 rounds of DHS Nepal -- weights? By: LeahBevis on Wed, 22 July 2020 16:12
		Re: Pooling 3 rounds of DHS Nepal -- weights? By: Bridgette-DHS on Sat, 25 July 2020 12:22
		Re: Pooling 3 rounds of DHS Nepal -- weights? By: LeahBevis on Mon, 27 July 2020 17:45

Previous Topic:	Combine weights Men and Women - Cambodia DHS
Next Topic:	How to Weight Data in R

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Nov 19 09:41:54 Coordinated Universal Time 2024