The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Struggling with merging Senegal KR data file to mother's file (Struggling with merging Senegal KR data to mother's info PR + IR)
Re: Struggling with merging Senegal KR data file to mother's file [message #18513 is a reply to message #18425] Wed, 11 December 2019 10:12 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3150
Registered: February 2013
Senior Member


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

If you try to merge the KR file with the PR file, there are four reasons why you may appear to lose cases:
(1) Children in the KR file will not be in the PR file if they have died (b16=.)
(2) Children in the KR file will not be in the PR file if they are not living with the mother (b16=0)
(3) Children in the PR file will not be in the KR file if their mother has died (hv112=.)
(4) Children in the PR file will not be in the KR file if they are not living with their mother (hv112=0)

Have you taken these possibilities into account? They will be identified after a merge by _merge= 1or 2 rather than 3. If this does not answer your question, please let us know.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Mismatch of file names within the same survey
Next Topic: Merge Other Biomarkers with HH
Goto Forum:
  


Current Time: Fri Aug 30 08:18:47 Coordinated Universal Time 2024