The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » INDIA - NFHS-4 - PR AND CR (MERGING PR AND CR in Stata.)
INDIA - NFHS-4 - PR AND CR [message #22401] Sun, 07 March 2021 12:49 Go to next message
novea is currently offline  novea
Messages: 1
Registered: March 2021

is there a way to merge both men and women, thus every couple, in the CR-file to the corresponding household in the PR-file? Since the only common identifiers with the PR-file can be v001 v002 v003 v024, for women, and mv001 mv002 mv003 mv024, for for men, I managed to merge only women or only men to the PR-file. I want to merge these files to basically only have information about household structure - shstruc from PR - without having to construct an indicator for it in the couple file.

I consulted all the available DHS technical guides and most of this forum to solve this, but I still did not find a solution.

Thank you and best regards.

[Updated on: Sun, 07 March 2021 14:10]

Report message to a moderator

Re: INDIA - NFHS-4 - PR AND CR [message #22415 is a reply to message #22401] Wed, 10 March 2021 07:52 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2537
Registered: February 2013
Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

If you want to merge household-level data with the CR file, then you do not need to use hvidx. From the household file, the identifier would be hv001 hv002 hv024 and from the CR file you would match that with EITHER v001 v002 v024 OR mv001 mv002 mv024. (In the CR file v001=mv001, v002=mv002, and v024=mv024.) For the household file, use either the HR version or the PR version. It would probably be easier to construct the household structure variables with the PR file and collapse it to one record per household.
Previous Topic: Merging variables of mothers' health status in IR file into KR file
Next Topic: Are the merging commands and results correct
Goto Forum:

Current Time: Thu Jun 30 09:05:24 Coordinated Universal Time 2022