The DHS Program User Forum: Weighting data

Home » Data » Weighting data » Appending files (Appending files for trend analysis)

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

Re: Appending files [message #22402 is a reply to message #22397]

Sun, 07 March 2021 16:28

Ugonna
Messages: 26
Registered: June 2020

Member

Thank you for your response.

Please what does the following weighting commands on an appended file of 3 datasets do, and is it necessary?

summarize wt
scalar N=r(N)
scalar Nshare=N/3
generate wt_new=wt

summarize wt if year==0
scalar sumwt_new =r(sum)
replace wt_new =wt *Nshare/sumwt_new if year==0

summarize wt if year==1
scalar sumwt_new =r(sum)
replace wt_new =wt *Nshare/sumwt_new if year==1

summarize wt if year==2
scalar sumwt_new =r(sum)
replace wt_new =wt *Nshare/sumwt_new if year==2

Thank you

Report message to a moderator

[Message index]

		Appending files By: Ugonna on Thu, 04 March 2021 17:09
		Re: Appending files By: Bridgette-DHS on Fri, 05 March 2021 19:12
		Re: Appending files By: Ugonna on Sun, 07 March 2021 16:28
		Re: Appending files By: Bridgette-DHS on Wed, 10 March 2021 07:56
		Re: Appending files By: Ugonna on Wed, 10 March 2021 17:46
		Re: Appending files By: Bridgette-DHS on Thu, 11 March 2021 15:48
		Re: Appending files By: Ugonna on Thu, 11 March 2021 18:47

Previous Topic:	Strata and PSUs in Egypt KR 2014 for sampling weight
Next Topic:	Pooled country analysis weighting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Sep 16 08:49:55 Eastern Daylight Time 2026