discrepancies after merging PR and IR/MR [message #6938] |
Wed, 05 August 2015 12:10 ![Go to next message Go to previous message](/theme/default/images/down.png) |
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
|
|
|