The DHS Program User Forum: Merging data files

Home » Data » Merging data files » husbands to their wives

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

husbands to their wives [message #16299]

Mon, 10 December 2018 10:13

memon_suma@yahoo.com
Messages: 15
Registered: April 2018

Member

Hi,
I am trying to asses the number of infant deaths experienced by women who ever had children in Pakistan. I need some determinants for my study of which husband's working status is also required as a control variable. I want to merge MR and IR file and use the code as follows;

use PKMR61FL.DTA, clear
rename mv001 v001
rename mv002 v002
rename mv003 v034
sort v001 v002 v034
keep v001 v002 v034 mv714
save mrir.dta, replace
use PKIR61FL.DTA
sort v001 v002 v034
merge m:1 v001 v002 v034 using mrir.dta

My women data has 13558 observations, but after executing the coded above it returns 13928 observations. The merge shows 2798 entries merged.
I am not being able to understand the process here. I mean I suppose the number of observations in the merged file to be the same as women's?
Please help!

Report message to a moderator

[Message index]

		husbands to their wives By: memon_suma@yahoo.com on Mon, 10 December 2018 10:13
		Re: husbands to their wives By: Bridgette-DHS on Wed, 12 December 2018 13:23
		Re: husbands to their wives By: memon_suma@yahoo.com on Thu, 13 December 2018 06:19
		Re: husbands to their wives By: Bridgette-DHS on Tue, 08 January 2019 08:46

Previous Topic:	Linking variables from SA 1998 HR, PR & IR files to Adult Health respondents
Next Topic:	How to merge PR & CR files in R

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 19 01:02:07 Coordinated Universal Time 2024