Hi all,

my data pretty much looks like the following

Code:
Year company var1
1999 CompanyA 0
2000 CompanyA 1
2001 CompanyA 0
2002 CompanyA 0
2010 CompanyB 0
2011 CompanyB 1
2012 CompanyB 0 
2013 CompanyB 0
What I want to do is I want to create a new dummy variable which is one year before and two years later from the current dummy. So I want it looks like the following:

Code:
Year Company var1 var2
1999 CompanyA 0 1
2000 CompanyA 1 0
2001 CompanyA 0 0 
2002 CompanyA 0 1
2010 CompanyB 0 1
2011 CompanyB 1 0 
2012 CompanyB 0 0
2013 CompanyB 0 1
How can I do this?

Thanks!