I'm trying to create a dummy variable list for sanctions events that have taken place over the past 60 years.
Please just look at the "Excel Forum" tab in the attached document since it is simplified.
Hypothetical Example:
Sanctions event:
1962 - 1965 | Argentina| 1 ("1" Signifies a sanction took place)
I would like this coded into:
Panel Data
1960 | Argentina | 0
1961 | Argentina | 0
1962 | Argentina | 1
1963 | Argentina | 1
1964 | Argentina | 1
1965 | Argentina | 1
1966 | Argentina | 0
1967 | Argentina | 0
You will already see in the attached excel document that I've already created an array formula to measure the start year. I just do not know how I can measure the end year and the years in-between.
The document has a highlighted example and comments to explain the situation event more.
Thank you for your help!
Bookmarks