Count observations with same ID during prior 3 years

[Juan Gonzalex]

Solved

[Clyde Schechter]

Rather than obliterating the original question and declaring it solved, it would have been more helpful to this community had you added to your thread by showing the solution. Others may encounter the same problem you originally asked for help with, and they would benefit from knowing how you solved it.