Dear group,

I have a question about looping over two tables. In my first table, I have a list of individuals for which I have the age, country of residence, gender and year of interview (I've inserted the first five observations below). In the second table, I have the official retirement ages for each year, country and gender. (I've inserted 5 retirement ages below)
In the first table, I created a variable called official retirement age.
What I have to do is to go through each individual in the first table and see if for the 4 variables (age, country, gender and year) there is a match with the second table. If yes, then I want to take the official retirement age from the second table and put it into the retirement age variable for that individual in the first table.
I understand that I have to do 2 loops, one that loops over the individuals and another one inside this loop that loops over the variables and if they match in the two tables, take the retirement age from the second table to the first table. Unfortunately, I don't know how to write this in code.
Could anyone help me with it?

Thank you in advance,
Rita Samudra