I would like to ask you how to assign a value of 1 (and 0 otherwise) if there was a change in the value of a variable, so that it was 10 or below 10 in the previous year, but in the next year got bigger then 10. I would also like to assign 1 if the value was 11 or bigger than 11 and is now smaller than 11.
In other words, I care for the borderline between 10 and 11 and whether the value of the variable trespassed that borderline, then it should trigger a change from 0 to 1.
Each observation has unique ID - which is a name and a year.
I have uploaded the excel file with the IDs and the values.
Thanks a lot!