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 next 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!
Re: How to merge KR file with PR file in NFHS-2 (1998-99) using stata [message #23042 is a reply to message #23041] Wed, 30 June 2021 10:19 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3196
Registered: February 2013
Senior Member
We have had countless postings on the topic of merging DHS datasets. If you search with keywords "merge" or "merging", you should find answers to your questions.

For additional information on merging, please see the examples in the Guide to DHS Statistics - search for "Matching and Merging Datasets". Also, please see the following page for more information on merging: https://dhsprogram.com/data/Merging-Datasets.cfm
Previous Topic: Indicators of level of asthma
Next Topic: District variable for NFHS3
Goto Forum:
  


Current Time: Mon Nov 18 22:35:16 Coordinated Universal Time 2024