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 #10184 is a reply to message #10170]

Tue, 05 July 2016 13:12

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Another response from Tom Pullum:

I don't use SPSS--just Stata. If hv005 is missing for some children in the merged file, they will be children who are in the KR file but not in the PR file. They will be children who died OR children who do not live in the household, even though their mother is in the household. The KR file includes children born in the past five years to the women who are in the IR file. Some of those children live elsewhere.

I would not expect you to lose hv005 just because of the sequence of the two files in the merge. Maybe that can happen in SPSS. I don't think it would happen in Stata. However, my normal practice is to start with the larger file and then merge the smaller file with it. Thus, in this case I would start with the PR file and then merge with the KR file, not the reverse.

You should get unique identifiers if you match hv001 hv002 hvidx in the PR file with v001 v002 b16 in the KR file.

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: Sat Jul 5 17:44:20 Coordinated Universal Time 2025