The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Matching IR PR KR (Combining 3 files)
Matching IR PR KR [message #24667] Thu, 16 June 2022 15:07 Go to next message
kmdshoyaib is currently offline  kmdshoyaib
Messages: 6
Registered: May 2022
Hi there, I would like to know if there is any common variable using which I can match and bring data in single SPSS file for IR, PR, KR. Any response is highly appreciated. Thanks
Re: Matching IR PR KR [message #24687 is a reply to message #24667] Tue, 21 June 2022 16:45 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 162
Registered: April 2022
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

There have been many postings on merging data from different files using Stata. The only thing that is special about the India surveys is that region must be included as part of the ID. For example, if you have a woman in the IR file and you want to find her in the PR file, then v025 and hv025 must match, v001 and hv001 must match, v002 and hv002 must match, and v003 and hvidx must match. That is, you match v025, v001, v002, v003 in the IR file with hv025, hv001, hv002, and hvidx in the PR file. The logic for merging in SPSS should be similar to what it is in Stata.
Previous Topic: Caste waves 2015-2019
Next Topic: Query on weight variable
Goto Forum:

Current Time: Sun Aug 14 09:35:11 Coordinated Universal Time 2022