The DHS Program User Forum: Weighting data » Sample weights disappear after merge household with childs recode

Home » Data » Weighting data » Sample weights disappear after merge household with childs recode

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

Re: Sample weights disappear after merge household with childs recode [message #10162 is a reply to message #10151]

Fri, 01 July 2016 12:25

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Another response from Tom Pullum:

I'm not sure what survey you are working with. I arbitrarily picked the 2013 survey of Nigeria. I will paste below the Stata lines to do what I think you are trying to do. There are no missing values of weights for the children who are in both surveys. Please tell me if I have misunderstood what you want to do.

set more off
use e:\DHS\DHS_data\KR_files\NGKR6AFL.dta, clear
keep v001 v002 v005 b5 b16
rename v001 hv001
rename v002 hv002
rename b16 hvidx
sort hv001 hv002 hvidx

save e:\DHS\scratch\NGKR6Atemp.dta, replace

use e:\DHS\DHS_data\PR_files\NGPR6AFL.dta, clear
keep hv001 hv002 hvidx hv005
sort hv001 hv002 hvidx
merge hv001 hv002 hvidx using e:\DHS\scratch\NGKR6Atemp.dta

codebook *v005 if _merge==3

* no missing values of v005 or hv005 for the children who are both files

Report message to a moderator

[Message index]

		Sample weights disappear after merge household with childs recode By: RKelders on Wed, 29 June 2016 11:13
		Re: Sample weights disappear after merge household with childs recode By: Bridgette-DHS on Wed, 29 June 2016 13:25
		Re: Sample weights disappear after merge household with childs recode By: RKelders on Fri, 01 July 2016 08:56
		Re: Sample weights disappear after merge household with childs recode By: Bridgette-DHS on Fri, 01 July 2016 12:25
		Re: Sample weights disappear after merge household with childs recode By: RKelders on Sat, 02 July 2016 10:36
		Re: Sample weights disappear after merge household with childs recode By: Bridgette-DHS on Tue, 05 July 2016 13:12
		Re: Sample weights disappear after merge household with childs recode By: RKelders on Wed, 06 July 2016 07:03
		Re: Sample weights disappear after merge household with childs recode By: Bridgette-DHS on Thu, 07 July 2016 10:09
		Re: Sample weights disappear after merge household with childs recode By: RKelders on Sun, 10 July 2016 09:04
		Re: Sample weights disappear after merge household with childs recode By: RKelders on Sun, 17 July 2016 10:09
		Re: Sample weights disappear after merge household with childs recode By: Bridgette-DHS on Mon, 18 July 2016 11:36
		Re: Sample weights disappear after merge household with childs recode By: RKelders on Tue, 19 July 2016 09:34
		Re: Sample weights disappear after merge household with childs recode By: Bridgette-DHS on Mon, 10 October 2016 08:18
		Re: Sample weights disappear after merge household with childs recode By: RKelders on Wed, 12 October 2016 12:08
		Re: Sample weights disappear after merge household with childs recode By: Bridgette-DHS on Thu, 13 October 2016 19:08
		Re: Sample weights disappear after merge household with childs recode By: RKelders on Wed, 26 October 2016 11:19

Previous Topic:	Using iweights for districts
Next Topic:	Mozambique weighting after merging datasets

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Aug 1 17:03:19 Coordinated Universal Time 2025