The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » CR-KR Merger (Syntax)
Re: CR-KR Merger [message #30014 is a reply to message #29994] Tue, 10 September 2024 12:32 Go to previous messageGo to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 891
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

In the NFHS-4 and -5, only 1/6 of men were interviewed, so at most 1/6 of children in the KR file will merge with the couples in the CR file. Moreover, we do not know that the woman's current partner is the father of the child. For example, the mother may have been widowed and remarried.

If you want to proceed, open the CR file and reduce it to v001, v002, v003, and the m* variables. The CR variables for the mother are already in the KR file and you don't need to copy them (you can check to see if there are exceptions). Save this file with a temporary name. Then open the KR file and do a m:1 merge with v001 v002 v003 in the temporary file (m:1 because there can be many children per mother). This will add the m* variables for the male partner to the child's record.
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: v717
Next Topic: Population for cause specific mortality rate from va dataset
Goto Forum:
  


Current Time: Wed Nov 27 00:47:07 Coordinated Universal Time 2024