The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Merging Height and Weight Data with KR files
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
andreaseiermann is currently offline  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

 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Latent Class Analysis
Next Topic: Adjusting sample weight for multilevel analysis- SPA dataset
Goto Forum:
  


Current Time: Sun Aug 18 13:28:39 Coordinated Universal Time 2024