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: 3201
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.

Report message to a moderator

[Message index]
 
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:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Mon Dec 2 06:56:50 Coordinated Universal Time 2024
.:: Contact :: Home :: Privacy Policy ::.

Powered by: FUDforum 3.0.9.
Copyright ©2001-2018 FUDforum Bulletin Board Software

The information provided on this Web site is not official U.S. Government information and
does not represent the views or positions of the U.S. Agency for International Development or the U.S. Government...