The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » How to merge KR file with PR file in NFHS-2 (1998-99) using stata (Merging PR files and KR files in NFHS-2(1998-99))
How to merge KR file with PR file in NFHS-2 (1998-99) using stata [message #23041] Wed, 30 June 2021 09:51 Go to previous message
byx_xi is currently offline  byx_xi
Messages: 1
Registered: June 2021
Member
Hello~

I am now processing the NFHS-2(1998-99) data using stata. I try to merge KR file with PR file (master file), but i can not construct unique identifiers.
using hv001 (cluster number), hv002 (household number) and hvidx (line number of household number) and unique identified code of each state in
hhid, unique identifiers are easily to established.

However, i can only find v001(cluster number) and v002 (household number) in KR file, but not similar variable as hvidx. only with v001 and v002 is
not enough. I have checked KR file for NFHS3 and NFHS4, the similar variable b16 truly exists which means child's line number in household ",with
which KR file and PR file can be perfectly matched.

I have also thought over to use v001, v002, age of household member in years, respondent's line number in KR file to construct unique individual key
identifiers, but it seems only helpful in the case of a mother with a single child, for twins or children with same age for a single mother this will not work.

In addition, for children have died in KR file certainly can not be matched in PR file, I have taken consider for it, but the problems mentioned above i have no ideas.

Please help me and give me some inspirations.Thank you!
 
Read Message
Read Message
Previous Topic: Indicators of level of asthma
Next Topic: District variable for NFHS3
Goto Forum:
  


Current Time: Mon Nov 18 20:51:34 Coordinated Universal Time 2024