I need your help for survival study.

Background:
I have corporate panel data set as Corporate codes, year, and various ratios.

Survival Study:
First year = 1 if PPE/Asset ratio > 1 in the earlier year
Last year = 1 if PPE/Asset ratio >1 in the later year

I have no idea how to do the set up above. Please teach me..