Re: CR-KR Merger [message #30014 is a reply to message #29994] |
Tue, 10 September 2024 12:32 |
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.
|
|
|