Support #1912
open
Merging newborn and child data Waves 11 & 12
100%
Description
Hello,
I am trying to look at breastfeeding data for waves 11 and 12, and note there is breastfeeding data in both k_child and k_newborn datasets. I am struggling to merge the two, and to find wider birth year data for the k_newborn set.
I gather that by using k_hidp and k_pno a unique identifier is created, however, I am not certain of whether the k_pno in k_newborn relates to the mother/parent or the newborn.
When I merge 1:1 in stata using pidp, or hidp, or k_hidp k_pno, it says none of these approaches uniquely identify the data. Will I have a valid data set if i merge m:1 or even m:m? It seems that these data sets (child and newborn) relate to largely different groups. However, I cannot be sure if this is because the newborn data is linked to the parent and not the newborn.
Lastly, if merging m:1 as above (I get 0 matches in stata if I do this), I still have incomplete birth year data for the newborn entries.
Many thanks for any advice.
Updated by