The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Weighted counts (Calculating weighted counts in DHS)
Weighted counts Tue, 26 March 2019 03:04
 siddu123 Messages: 1Registered: March 2019 Member
I am trying to calculate weighted counts in stata for India 2014-15 MR dataset.

1)From my understanding, individual observations when multiplied with weights, should give the count of the actual population.

For example. The total percent of men who have diabetes is 2.13%. Which in the weighted count (table below) shows a value of 2396. However my understanding is that the weighted count must show some 35-million (approx) cases of men who are actually diabetic in India.

2)Also is there any problem in using scaled singleunit for svy instead of "missing"?

3) is there a difference in iweight and pweight?

These are my codes. MRdataset.

generate wgt = mv005/1000000
svyset mv021 [pweight=wgt], strata(mv022) vce(linearized) singleunit(scaled)
recode sm622a (8=0) , gen (CurrentlyDiabetic)

. svy linearized : tabulate mv102 CurrentlyDiabetic, count row percent format(%16.0g)
(running tabulate on estimation sample)

Number of strata = 2508 Number of obs = 112122
Number of PSUs = 9887 Population size = 112122
Design df = 7379

------------------------------------------------------------ -
type of |
place of | RECODE of sm622a (currently has diabetes)
residence | 0 1 Total
----------+------------------------------------------------- -
urban | 41789.450922453 1163.0585127594 42952.509435213
| 97.292222205285 2.7077777947146 100
|
rural | 67936.373593395 1233.1175029331 69169.491096328
| 98.217252312561 1.782747687439 100
|
Total | 109725.82451585 2396.1760156925 112122.00053154
| 97.862885067754 2.137114932246 100
------------------------------------------------------------ -
Key: weighted counts
row percentages

Pearson:
Uncorrected chi2(1) = 108.4122
Design-based F(1, 7379) = 23.9928 P = 0.0000

Note: Variance scaled to handle strata with a single sampling unit.

 Weighted counts By: siddu123 on Tue, 26 March 2019 03:04 Re: Weighted counts By: Bridgette-DHS on Thu, 28 March 2019 11:35
 Previous Topic: weighting tabulations for 2 way tables Next Topic: using weights to make a provincial level data representative at district level
Goto Forum:

Current Time: Thu Dec 1 21:42:03 Coordinated Universal Time 2022