Hello everybody,
I'm working on the 2009 socio economica Ghana panel survey for my final thesis. I'm having some problem merging 2 datasets.
I would like to merge them using "hhno" and "hhmid" code, however the presence of some duplicates prevent me from doing that.
Honestly, I would like to avoid to drop the duplicates as they contain relevant information for the purpose of my reserach.
Whenever I want to merge the datasets, Stata gives me the r(459) error message variables "hhno" and"hhmid" do not uniquely identify observations in the master data.
Is there a way to merge the data keeping the data of the duplicates?
I enclosed a picture of the 2 datasets at issue.
Thanks in advance
I'm working on the 2009 socio economica Ghana panel survey for my final thesis. I'm having some problem merging 2 datasets.
I would like to merge them using "hhno" and "hhmid" code, however the presence of some duplicates prevent me from doing that.
Honestly, I would like to avoid to drop the duplicates as they contain relevant information for the purpose of my reserach.
Whenever I want to merge the datasets, Stata gives me the r(459) error message variables "hhno" and"hhmid" do not uniquely identify observations in the master data.
Is there a way to merge the data keeping the data of the duplicates?
I enclosed a picture of the 2 datasets at issue.
Thanks in advance
Comment