The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Child Unique Identifier
Child Unique Identifier [message #8837] Wed, 30 December 2015 05:38 Go to next message
faiz_economics is currently offline  faiz_economics
Messages: 3
Registered: August 2015
Location: Islamabad

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,
Re: Child Unique Identifier [message #8905 is a reply to message #8837] Tue, 12 January 2016 13:39 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1763
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.
Previous Topic: matching periodic data on same individual over several DHS periods
Next Topic: Duplicates in IR file when merging
Goto Forum:

Current Time: Sat Mar 28 20:35:17 Eastern Daylight Time 2020