Hey all,

I am using panel data and have a full population dataset. I can observe an individuel over time, their age and their retirement status (dummy variable). I would like to generate a variable over their retirement age by ID.

I tried the following code:

by ID_nr: gen retirement_age = age if retirement == 1
by ID_nr: replace retirement_age = min(retirement_age)

However, it does unfortunately not work.

Can anyone help?

Thank you in advance!