The DHS Program User Forum: Merging data files » discrepancies after merging PR and IR/MR

Home » Data » Merging data files » discrepancies after merging PR and IR/MR

Show: Today's Messages :: Show Polls :: Message Navigator

discrepancies after merging PR and IR/MR [message #6938]

Wed, 05 August 2015 12:10

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

Report message to a moderator

[Message index]

		discrepancies after merging PR and IR/MR By: fabienne on Wed, 05 August 2015 12:10
		Re: discrepancies after merging PR and IR/MR By: Bridgette-DHS on Fri, 07 August 2015 10:52

Previous Topic:	Weighting after Merging
Next Topic:	merging children's file and wealth index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Jan 1 02:36:11 Coordinated Universal Time 2025