| Re: Weighting data [message #3028 is a reply to message #3013] |
Mon, 06 October 2014 10:23   |
Bridgette-DHS
Messages: 3216
Registered: February 2013
|
Senior Member |
|
|
Here is additional comments from Senior Specialist, Tom Pullum:
If all you want to do is to calculate mean household size, then you do not need to make an adjustment for clusters and strata. That adjustment only affects the estimates of standard errors. You just need the adjustment for weights. You can use this with the HR file (NPHR60FL.dta):
summarize hv009 [iweight=hv005/1000000]
Or you can do the following (for pweights, it is not necessary to divide by 1000000):
svyset [pweight=hv005]
svy: mean hv009
Both of those will give 4.6289, which is probably what you were getting and does not match with the value in the report, 4.4. The reason you are not getting 4.4 is that the DHS figure is limited to de facto members of households, i.e. respondents for whom hv103=1 rather than 0. Try the following, with the PR file rather than the HR file, i.e. with NPPR60FL.dta:
collapse (sum) hv103 (first) hv005, by(hhid)
summarize hv103 [iweight=hv005/1000000]
This will give a mean of 4.39408, which matches the report.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
