Hi All!
I am working with Panel Study of Income Dynamics (PSID). I need to get details about the marriage history of the parents. The final goal is to understand if the marriage behavior of the parent affects child's cognitive skills measure by some test scores. I have two dta files, one has information on child id (pid_ch), her parent's id (pid_m (mom) and pid_d (dad)) in the following format (there are many missing values, especially for single mos)
The other file has the marriage history of mother and father
Now I want to merge the two files, so I can link the child to the parent's marriage history. Once I have done that, I will use the test score data to see if there is any correlation between parent's marriage history (divorce or more than one marriage) on the child's outcome. The problem is that it seems that I need to do a m:m merge and that is strongly discouraged. I will be very grateful if someone could please help me with merging the data such that I can link children to their parent's marriage history.
Many thanks in advance.
I am working with Panel Study of Income Dynamics (PSID). I need to get details about the marriage history of the parents. The final goal is to understand if the marriage behavior of the parent affects child's cognitive skills measure by some test scores. I have two dta files, one has information on child id (pid_ch), her parent's id (pid_m (mom) and pid_d (dad)) in the following format (there are many missing values, especially for single mos)
pid_ch | pid_m | pid_d |
1001 | 2002 | 4002 |
1002 | 2002 | . |
1003 | 4907 | 3500 |
1004 | 4909 | 5473 |
1005 | 5120 | 5473 |
sex | marriage year | divorce year | separation year | no of marriages | pid_m | pid_d | |
2 | 1935 | 1935 | . | 2 | 2002 | 4002 | |
1 | 1936 | 1970 | . | 2 | 2002 | . | |
2 | 1942 | 1950 | 1948 | 3 | 4907 | 3500 | |
2 | 1984 | . | . | 1 | 4909 | 5473 | |
1 | 2008 | . | 2021 | 1 | 5120 | 5473 |
Many thanks in advance.
Comment