The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Merging DHS data in Stata

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

Re: Merging DHS data in Stata [message #9796 is a reply to message #9784]

Thu, 19 May 2016 10:14

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

This should work. You will get the same results with wgt=hv005/1000000 or with wgt=hv005. There is no need to divide by 1000000 because Stata automatically re-normalizes pweights to have a mean of 1. For the psu you can use hv021 or hv001. They are identical.

There is typically a small difference between the weight for the same woman in the PR file and in the IR files. That is, her value of hv005 and v005 can be a little different. Similarly for a child. Similarly, hv005 and mv005 for the same man may differ. This is because of adjustments for nonresponse in the IR and MR files. However, given how you have constructed your file, I think it will be ok to use hv005 as the weight for the household units.

Report message to a moderator

[Message index]

		Merging DHS data in Stata By: DHS user on Wed, 20 February 2013 11:45
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 20 February 2013 11:46
		Re: Merging DHS data in Stata By: kf2349 on Tue, 26 March 2013 16:20
		Re: Merging DHS data in Stata By: Bridgette-DHS on Thu, 28 March 2013 09:25
		Re: Merging DHS data in Stata By: jack.murphy on Tue, 15 November 2016 11:26
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 16 November 2016 09:32
		Re: Merging DHS data in Stata By: jack.murphy on Thu, 17 November 2016 16:53
		Re: Merging DHS data in Stata By: Bridgette-DHS on Fri, 18 November 2016 10:31
		Re: Merging DHS data in Stata By: jack.murphy on Fri, 18 November 2016 11:28
		Re: Merging DHS data in Stata By: jack.murphy on Fri, 18 November 2016 11:38
		Re: Merging DHS data in Stata By: Bridgette-DHS on Fri, 18 November 2016 14:36
		Re: Merging DHS data in Stata By: jack.murphy on Fri, 18 November 2016 14:37
		Re: Merging DHS data in Stata By: Hassen on Sun, 06 May 2018 05:58
		Re: Merging DHS data in Stata By: caragh on Tue, 02 April 2013 18:46
		Re: Merging DHS data in Stata By: Bridgette-DHS on Tue, 09 April 2013 12:07
		Re: Merging DHS data in Stata By: owraza on Sat, 28 June 2014 20:38
		Re: Merging DHS data in Stata By: Bridgette-DHS on Mon, 30 June 2014 13:20
		Re: Merging DHS data in Stata By: owraza on Wed, 02 July 2014 07:24
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 02 July 2014 10:21
		Re: Merging DHS data in Stata By: kinsukmanisinha@gmail.com on Wed, 14 October 2015 09:38
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 21 October 2015 13:55
		Re: Merging DHS data in Stata By: mianrashid on Tue, 10 May 2016 10:01
		Re: Merging DHS data in Stata By: owraza on Tue, 10 May 2016 15:24
		Re: Merging DHS data in Stata By: mianrashid on Tue, 10 May 2016 17:04
		Re: Merging DHS data in Stata By: owraza on Tue, 10 May 2016 20:33
		Re: Merging DHS data in Stata By: Bridgette-DHS on Thu, 12 May 2016 09:08
		Re: Merging DHS data in Stata By: mianrashid on Tue, 17 May 2016 13:01
		Re: Merging DHS data in Stata By: Bridgette-DHS on Thu, 19 May 2016 10:14
		Re: Merging DHS data in Stata By: phres110 on Wed, 02 November 2016 13:29
		Re: Merging DHS data in Stata By: Bridgette-DHS on Fri, 11 November 2016 10:27
		Re: Merging DHS data in Stata By: Malachi Arunda on Sat, 16 May 2015 07:39
		Re: Merging DHS data in Stata By: Malachi Arunda on Sat, 16 May 2015 07:46
		Re: Merging DHS data in Stata By: Bridgette-DHS on Tue, 19 May 2015 11:14
		Re: Merging DHS data in SPSS By: Malachi Arunda on Sun, 24 May 2015 08:29
		Re: Merging DHS data in Stata By: Malachi Arunda on Sat, 30 May 2015 13:46
		Re: Merging DHS data in Stata By: Bridgette-DHS on Mon, 01 June 2015 13:00
		Re: Merging DHS data in Stata By: Malachi Arunda on Tue, 09 June 2015 23:21
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 10 June 2015 10:41
		Re: Merging DHS data in Stata By: Malachi Arunda on Tue, 04 August 2015 17:55
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 05 August 2015 10:04
		Re: Merging DHS data in Stata By: Malachi Arunda on Wed, 05 August 2015 13:22
		Re: Merging DHS data in Stata By: Malachi Arunda on Sun, 30 August 2015 06:21
		Re: Merging DHS data in Stata By: Reduced-For(u)m on Sun, 30 August 2015 14:36
		Re: Merging DHS data in Stata By: Reduced-For(u)m on Sun, 30 August 2015 14:37
		Re: Merging DHS data in Stata By: Malachi Arunda on Mon, 31 August 2015 12:27
		Re: Merging DHS data in Stata By: Reduced-For(u)m on Mon, 31 August 2015 15:10
		Re: Merging DHS data in Stata By: Malachi Arunda on Mon, 31 August 2015 15:43
		Re: Merging DHS data in Stata By: PublicHealthMaster on Fri, 11 September 2015 08:45
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 30 September 2015 07:31
		Re: Merging DHS data in Stata By: pie on Tue, 02 June 2020 06:21
		Re: Merging DHS data in Stata By: Bridgette-DHS on Fri, 05 June 2020 15:32

Previous Topic:	How to match women to their husbands
Next Topic:	Merging HR and PR Files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Dec 25 10:00:08 Coordinated Universal Time 2024