The DHS Program User Forum: Merging data files » Duplicates in IR file when merging

Home » Data » Merging data files » Duplicates in IR file when merging

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

Re: Duplicates in IR file when merging [message #8784 is a reply to message #8688]

Thu, 17 December 2015 11:19

nholla
Messages: 13
Registered: May 2015

Member

Thank you for your detailed explanation this. Given that the shconces variable is only on the household file, how could I merge this additional identifer onto the individual and birth recode files? I can't merge on hv001 hv002 since this doesn't uniquely identify households (I guess I could do an m:m merge but I'm hesitant to do this).

My whole purpose in doing this is to just get the mother contraception variable onto the birth recode file. In order to simplify things, am I ok in just using the caseid in these cases to merge the two files together?

Also, suppose I want to output descriptive statistics on the characteristics only of the mothers of the children recorded in the birth recode file. (I'm describing the characteristics of a subsample of children in this file, and subsequently am describing the characteristics of their mothers). Am I safe in deleting duplicates in terms of the caseid of the mom to narrow my file down to 1 observation per mother? Here I'm assuming that observations for every "mom" variable in the birth recode (such as education, marital status, etc) are the same given the same caseid. I was going to do a similar thing for households, but given the extra variable problem above I'm unsure whether I just delete duplicates on v001 v002 given the issue with shconces.

Thanks!

Report message to a moderator

[Message index]

		Duplicates in IR file when merging By: nholla on Tue, 24 November 2015 20:25
		Re: Duplicates in IR file when merging By: Bridgette-DHS on Wed, 02 December 2015 08:14
		Re: Duplicates in IR file when merging By: nholla on Thu, 17 December 2015 11:19
		Re: Duplicates in IR file when merging By: Bridgette-DHS on Wed, 13 January 2016 08:18

Previous Topic:	Child Unique Identifier
Next Topic:	Malaria Indicator Survey: Malaria outcomes and women's characteristics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 25 20:52:06 Coordinated Universal Time 2025