Hello,
I have two data-sets I would like to merge. The first data set is of elections, so each observation is at the state-year level. The second set is at the individual level. For each individual I see state she lives in and year of birth.
I want to merge the data sets so that individuals would be linked elections. Specifically, I want an individual to be linked to an eleciton if the individual was 18-30 years old when the election took place. So the merging process would be over a set of years for every individual, and not over a specific year.
Moreover the same individual may be linked via this process to more than one elections. In this case I want to link the individual only to the latest elections.
How could I achieve this?
Thank you very much.
I have two data-sets I would like to merge. The first data set is of elections, so each observation is at the state-year level. The second set is at the individual level. For each individual I see state she lives in and year of birth.
I want to merge the data sets so that individuals would be linked elections. Specifically, I want an individual to be linked to an eleciton if the individual was 18-30 years old when the election took place. So the merging process would be over a set of years for every individual, and not over a specific year.
Moreover the same individual may be linked via this process to more than one elections. In this case I want to link the individual only to the latest elections.
How could I achieve this?
Thank you very much.
Comment