The DHS Program User Forum: Weighting data » Why I am getting different total observations when using iweight for tabulating a variable

Home » Data » Weighting data » Why I am getting different total observations when using iweight for tabulating a variable

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

Re: Why I am getting different total observations when using iweight for tabulating a variable [message #26536 is a reply to message #26135]

Thu, 30 March 2023 07:02

sujata
Messages: 18
Registered: May 2019

Member

Dear Tom,
In addition to the above queries, I am facing another issue while applying the normalized weight to compute fractional rank. the fractional rank is r_i=∑ w_j+w_i/2
where j varies from 0 to i-1. for the same, I applied the following commands, but the mean of the fractional rank is not exactly 0.5. It is 0.4857. sv271 is the wealth index factor score for state-level studies. My study is on the Indian state of Punjab. I am following the world bank document "Analyzing health equity using household survey data" for your reference.

sort sv271s
egen raw_rank=rank(sv271s), unique
sort raw_rank

qui sum wgt_shweight_PR
gen wi = wgt_shweight_PR/r(sum)
gen cusum = sum(wi)
gen wj= cusum[_n-1]
replace wj=0 if wj==.
gen rank_CE=wj+0.5*wi

here wgt_shweight_PR is generated so that the mean is equal to 1. below are the commands used to normalize the weights in PR file:

gen unwtd=1000000
total unwtd shweight
matrix B=e(b)
matrix list B
scalar sfactor=B[1,1]/B[1,2]
scalar list sfactor
gen shweight_PR=round(sfactor*shweight)
gen wgt_shweight_PR= shweight_PR/1000000

Please let me know where I am going wrong.

Report message to a moderator

[Message index]

		Why I am getting different total observations when using iweight for tabulating a variable By: sujata on Tue, 07 February 2023 12:48
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: Bridgette-DHS on Thu, 09 February 2023 09:11
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: sujata on Thu, 09 February 2023 11:45
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: Bridgette-DHS on Thu, 09 February 2023 13:12
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: sujata on Fri, 10 February 2023 01:31
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: Bridgette-DHS on Fri, 10 February 2023 07:58
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: sujata on Fri, 10 February 2023 10:49
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: sujata on Thu, 30 March 2023 07:02
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: Bridgette-DHS on Thu, 30 March 2023 11:04
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: sujata on Fri, 31 March 2023 07:56
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: Bridgette-DHS on Fri, 31 March 2023 12:03
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: sujata on Sat, 01 April 2023 02:23
		Re: Why I am getting different total observations when using iweight for tabulating a variable By: Bridgette-DHS on Mon, 03 April 2023 08:35

Previous Topic:	Multilevel model with region random effects
Next Topic:	Response rate and weights

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jul 26 14:46:24 Coordinated Universal Time 2024