Re: Merging Height and Weight Data with KR files [message #15758 is a reply to message #1445] |
Tue, 11 September 2018 04:26 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
andreaseiermann
Messages: 3 Registered: September 2018 Location: Heidelberg, Germany
|
Member |
|
|
This is an old post and your problem has probably been solved. But I ran into a similar problem and thought I'd share my solution in case someone in the future ends up on this thread (as I did) - for the record: I was working with Bangladesh 2004 data for this.
v001 v002 and b16 do not uniquely identify records in the KR file as long as children who are dead are in the KR file (b16 will be missing for them which doesn't seem to identify a record as different from non-missing). After removing all dead children (which I don't need for my analysis anyways - maybe recoding them to a random high value would work as well), I still had one problematic case, which was a child with b16==0 (which signifies children who are not listed in the household) for a woman with two children who were not in the household. After dropping these two children as well, v001 002 and b16 were unique identifiers and my merge worked.
[Updated on: Tue, 11 September 2018 04:52] Report message to a moderator
|
|
|