The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » discrepancies after merging PR and IR/MR
discrepancies after merging PR and IR/MR [message #6938] Wed, 05 August 2015 12:10 Go to previous message
fabienne is currently offline  fabienne
Messages: 6
Registered: March 2015
Member
Hello everyone

I am working with the DHS VI from Liberia.

I appended the women file (IR) and the men file (MR) and merged it to the household member file (PR), which resulted in 48,219 observations and 13,357 matches (merged on: v001 v002 v003).

To check the success of the merging process, I looked at the consistency of variables which are given in both the individual (IR/MR) datasets and the household (PR) dataset:
- hv105 and (m)v012 (Age of respondent)
- hv106 and (m)v106 (highest educational level)

Unfortunately, I found 2990 age and 691 education discrepancies. Commonly, the age discrepancies are small (1 year). Does this indicate a failed merge (which I do not believe) or is there a methodological explanation for this effect? Which age and education variable is more trustworthy and should be used for further analysis?

Thank you and best regards, Fabienne
 
Read Message
Read Message
Previous Topic: Weighting after Merging
Next Topic: merging children's file and wealth index
Goto Forum:
  


Current Time: Thu Mar 28 06:00:57 Coordinated Universal Time 2024