The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Child Unique Identifier

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

Child Unique Identifier [message #8837]

Wed, 30 December 2015 05:38

faiz_economics
Messages: 3
Registered: August 2015
Location: Islamabad

Member

Dear DHS Specialist,

I have merged IR (Women's) file with the KR (Kids') file using the following command. merge 1:m v001 v002 v003 using KR. It merges properly, however, i am unable to get Unique Identifier for every child. There is a repetition of child number in the merged file. How can i get the Unique Identifier. I am working on Pakistan's DHS 2006-07 and 2012-13.

Regards and Thanks,
Faiz

Report message to a moderator

Re: Child Unique Identifier [message #8905 is a reply to message #8837]

Tue, 12 January 2016 13:39

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

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

The combination v001 v002 v003 will identify the mother. A mother will appear once in the IR file, but she will appear multiple times in the KR file, once for each child born in the past five years. The unique identifier for the child will be the combination v001 v002 v003 bidx. For a given mother, bidx will be 1, 2, etc., for the children born in the past five years.

Report message to a moderator

Previous Topic:	matching periodic data on same individual over several DHS periods
Next Topic:	Duplicates in IR file when merging

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Dec 24 23:37:56 Coordinated Universal Time 2024