Support #2105
openHow to link parents-children using income variable between BHPS and UKHLS datasets
80%
Description
Dear Sir or Madam,
I am doing a research project on intergenerational income mobility by using BHPS and UKHLS data. For my research project, I need to make a linkage which matches parents who are in the BHPS dataset with their children who are in the UKHLS dataset. For example, I would like to match the incomes of parents who were surveyed in Wave 1 of the BHPS (Wave ba) with the income of their children who were surveyed in Wave 13 of the UKHLS (Wave m).
I have read some of the discussions on the UKHLS Support Forum to my question but cannot find a solution to my problem from them. So far, I have extracted the identifiers of parents (fnpid and mnpid) from the indall dataset for Wave 1 of the BHPS and merged the ba_indall dataset with the ba_indresp dataset to obtain the gross monthly labour income of parents. Following the same procedure, I have also merged the indall and indresp dataset for Wave 13 of the UKHLS to obtain the gross monthly labour income of children.
By using the unique personal identifier “pidp”, when I try to link my newly formed parent dataset (Wave 1 of BHPS) with the children dataset (Wave 13 of the UKHLS),as shown above, on an one-tone basis in STATA in order to form matched parent-children pairs (and/or father-son pairs, mother-son- pairs, father-daughter pairs, mother-daughter pairs), I frequently receive the error message “the variable “pid“/ “pidp” does not uniquely identify the observations in the master dataset”. Although I understand there are two unique personal identifiers of “pid” and “pidp” in the BHPS and UKHLS datasets and I tried both of them for linking, still I could not find a solution for matched parent-children pairs that I needed.
I sincerely thank you so much to provide me advice, guidance and support for my problem.
Have a very nice day.
Peter
Files