The DHS Program User Forum: Merging data files

Home » Data » Merging data files » ID variables for Children

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

Re: ID variables for Children [message #10049 is a reply to message #10048]

Mon, 20 June 2016 08:05

Bridgette-DHS
Messages: 3216
Registered: February 2013

Senior Member

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

In the KR and BR files, "caseid" is the unique id code for the mother, constructed from v001, v002, and v003 (v003 is the woman's line number in the household files, that is, hvidx). caseid is the unique id for the woman, but not for her children, because a woman who has had children will often have had more than one. For the children in the KR and BRfiles, you need to use the combination of caseid (or v001, v002, v003) and bidx. bidx is 1 for the most recent child, 2 for the next most recent, etc. Hope that helps--let me know if you have other questions.

P.S. I suggest that you open a KR or BR file in Stata and enter something like this: "list caseid v001 v002 v003 bidx if _n<=100, table clean". This should show what I mean.

Report message to a moderator

[Message index]

		ID variables for Children By: DHS user on Mon, 20 June 2016 07:52
		Re: ID variables for Children By: Bridgette-DHS on Mon, 20 June 2016 08:05

Previous Topic:	What is the underlying criteria for merging datasets from various waves?
Next Topic:	Merging DHS Files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jan 3 02:23:11 Coordinated Universal Time 2025