Confirming the correctiness of mereging two datasets [message #25738] |
Fri, 02 December 2022 07:08 ![Go to next message Go to previous message](/theme/default/images/down.png) |
gebretsh@gmail.com
Messages: 17 Registered: June 2022
|
Member |
|
|
Dear DHS experts,
As usual, I would like to thank you for the much-needed assistances you provide to me on questions I pose related to DHS data.
I merged the 2000 KR file with the 2000 wealth index file in Stata. The observations in the KR file are 10873 and in the WI, they are 14072. Now, after I merged the two data, the result shows that all 10873 observations in the KR are matched with the WI observations. However, the unmatched observations from the WI file are 7095, far more than I normally expect (14072-10873=3199). I guess that this would happen since I use many-to-one merge, but I am not quite sure whether this is true, and I kindly bring it to your attention for confirmation.
Regards,
|
|
|