The DHS Program User Forum: Dataset use in Stata » Stata weights vs CSPro weights

Home » Data » Dataset use in Stata » Stata weights vs CSPro weights (CSPro weighted value is different with stata value)

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

Stata weights vs CSPro weights [message #17895]

Mon, 08 July 2019 02:06

coach1327
Messages: 1
Registered: April 2019

Member

Hi, I am currently doing a study on domestic violence using the Philippines 2017 DHS datasets. When I do frequency for CSPro using the following:
V044
Universe = v502 in 1:2
weight = d005/1000000

I get the published value of 11,558.

But doing the same variable in Stata using [aw=d005]
I get a value of 13,215, which is also the UNWEIGHTED value in CSPro.

What am I missing in Stata?

Thank you guys in advance!

Val

Report message to a moderator

Re: Stata weights vs CSPro weights [message #17923 is a reply to message #17895]

Thu, 18 July 2019 08:48

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

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

There is not really an issue here. When you use d005 in Stata as a pweight, you should get exactly the same results that CSPro gets. The difference you describe has to do with whether the weight has been normalized in such a way that the weighted total equals the unweighted total. Stata always normalizes the weights (with pweight), without you asking it to. I encourage you to check this by using Stata with d005 to match something in the DV chapter in the main report. Let us know if you have trouble getting a match.

Report message to a moderator

Previous Topic:	Additional versions in Zip File
Next Topic:	Duplicated label categories

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Oct 16 14:32:07 Coordinated Universal Time 2025