The DHS Program User Forum: Merging data files » STATA codes to merge women and household datasets

Home » Data » Merging data files » STATA codes to merge women and household datasets

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

Re: STATA codes to merge women and household datasets [message #18042 is a reply to message #18038]

Sat, 24 August 2019 09:56

Isabelle
Messages: 2
Registered: July 2019

Member

Thank you Bridgette for your response and help.

However, I have a follow up question after merging the datasets including forth identifier v024/hv024.

When merging the datasets IR and PR using

household member:
gen int v001 = hv001
gen int v002 = hv002
gen byte v003 = hv003
gen int v024 = hv024
sort v001 v002 v003 v024

individual:
sort v001 v002 v003 v024
merge 1:m v001 v002 v003 v024 using "C:\Users\Isabelle\Desktop\DHS Data India\Single Datasets Recode\1998-99Recode\V21998-99HHMSort.dta"

I get the following result:
not matched: 337,481
from master 49,203
from using: 288,278

matched: 229,101

The household dataset has 517,379 observations
The individual dataset has 90,582 observation

Does this mean that from my master (individual) file, only (90,582-49,203) 41,379 individuals are not matched to a household; meaning I cannot use them in my further analysis?

Thank you in advance for your help!
Best
Isabelle

Report message to a moderator

[Message index]

		STATA codes to merge women and household datasets By: Mrinal on Fri, 26 January 2018 11:53
		Re: STATA codes to merge women and household datasets By: Bridgette-DHS on Mon, 29 January 2018 20:05
		Re: STATA codes to merge women and household datasets By: Mrinal on Tue, 30 January 2018 03:28
		Re: STATA codes to merge women and household datasets By: boyle014 on Thu, 01 February 2018 11:14
		Re: STATA codes to merge women and household datasets By: Mrinal on Mon, 05 February 2018 01:07
		Re: STATA codes to merge women and household datasets By: boyle014 on Mon, 05 February 2018 13:08
		Re: STATA codes to merge women and household datasets By: Gowokani on Wed, 18 April 2018 18:52
		Re: STATA codes to merge women and household datasets By: boyle014 on Fri, 20 April 2018 14:00
		Re: STATA codes to merge women and household datasets By: priyoma on Tue, 23 October 2018 17:18
		Re: STATA codes to merge women and household datasets By: boyle014 on Thu, 01 November 2018 17:20
		Re: STATA codes to merge women and household datasets By: Isabelle on Sun, 11 August 2019 08:48
		Re: STATA codes to merge women and household datasets By: Bridgette-DHS on Fri, 23 August 2019 13:40
		Re: STATA codes to merge women and household datasets By: Isabelle on Sat, 24 August 2019 09:56
		Re: STATA codes to merge women and household datasets By: Bridgette-DHS on Tue, 03 September 2019 15:37
		Re: STATA codes to merge women and household datasets By: vpatil on Sun, 26 April 2020 00:54

Previous Topic:	SPA 2012-2017 Senegal
Next Topic:	sample weights in women file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jan 9 16:30:32 Coordinated Universal Time 2025