The DHS Program User Forum: Merging data files » Merging mother's data with children's data in SAS

Home » Data » Merging data files » Merging mother's data with children's data in SAS

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

Re: Merging mother's data with children's data in SAS [message #11620 is a reply to message #11596]

Tue, 17 January 2017 16:08

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

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

Yes, caseid is always the id for the woman. It is a character string that includes v001 v002 v003. It is the same in the IR, KR, and BR files.

The child's record in the KR file (or the BR file) includes almost all the information about the mother that is in the IR file. There is no need to merge the KR and IR files.

A child in the KR file is uniquely identified by v001 v002 v003 bidx, where v001 v002 v003 identify the woman in the IR file and bidx identifies the child's order in the birth history (bidx=1 for the most recent birth).

Please ask again if this does not answer your question.

Report message to a moderator

[Message index]

		Merging mother's data with children's data in SAS By: Benita on Thu, 12 January 2017 15:20
		Re: Merging mother's data with children's data in SAS By: Bridgette-DHS on Fri, 13 January 2017 08:30
		Re: Merging mother's data with children's data in SAS By: Benita on Fri, 13 January 2017 17:02
		Re: Merging mother's data with children's data in SAS By: Bridgette-DHS on Tue, 17 January 2017 16:08

Previous Topic:	Creating unique household id in Women's data
Next Topic:	Merging/Appending files into one combined dataset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Dec 22 04:58:11 Coordinated Universal Time 2024