This is my first post, I hope I express myself and my question in an understandable manner.

I have panel data on all countries (variable name: country) and on their respective oil discoveries from 1868 to 2014 (variable name: year). I created a dummy variable that takes the value 1 if in a given year and country oil was discovered, and is 0 otherwise (discovery_dummy).

Now I want to create a dummy variable that takes value 1, if in the 10 years prior to the oil discovery, another oil discovery occurred in the same country.

Is there a code that allows generating a dummy that indicates whether in the same country in which oil was discovered, 10 years prior to the oil discovery, oil had already been discovered? This code would have to somehow flexible apply the ten year period to the entire year range of 1868-2014 and account for oil discoveries within each country.

Thanks in advance!