There are many ways to solve this.
One could be to join the table with itself, with a join condition like a.year = year+1.
Another would be some kind of data step processing using retain, but that would require the data to be sorted first.
What has PROC HADOOP to do with anything in your inquiry?
... View more
