| 2014 Kenya DHS merging household and men's datafile [message #10138] |
Thu, 30 June 2016 08:57  |
laura
Messages: 6
Registered: June 2016
|
Member |
|
|
Hello,
I would like to merge the household and men's data files to use in my analysis.
However, I have tried to merge using the household number but I get the error message
"variable hv002 does not uniquely identify observations in the master data"
I am using this command
"merge 1:m hv002 using KEKR70FL"
NB: I renamed the household number in the men's datafile from mv002 to hv002
Kindly how do I go about merging the two data files as I cannot identify any other variable which I can use as an identifier.
Thank you.
Laura
[Updated on: Thu, 30 June 2016 09:10] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: 2014 Kenya DHS merging household and men's datafile [message #10196 is a reply to message #10145] |
Thu, 07 July 2016 10:11  |
Bridgette-DHS
Messages: 3035
Registered: February 2013
|
Senior Member |
|
|
Another response from Tom Pullum:
The MR file is for "men", not "males", and like the IR file has a minimum age of 15. (The maximum age varies for men, but is usually 49 or 54 or 59.) My previous answer was probably misleading--I guess I didn't understand that you were just interested in the ages for school attendance. If you do this merge you will get some men/boys at ages 15 to 17 or 18 ( or whatever age you could take as the top age for school attendance) but you will not get any below age 15. The same for women/girls; you won't find anyone below age 15 in the IR file.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
