Hi, everyone,


I would greatly appreciate the help that you can give me, it is the following, I have a panel data structure, in long format, where for each id there can be more than one record as i show bellow

id month year income
1 03 2016 20,000
1 02 2016 15,000
1 01 2016. 35,000
2 02. 2016. 40,000
2 03. 2016. 45,000

I need to obtain is that, for each id (subject), leave only the entry of the last declared date, that is, I would need the final base to be in this way

id month year income
1 03 2016 20000
2 03 2016 45000


I would greatly appreciate your help to solve this problem, thank you very much in advance,

Regards,

Ariel.