Dear Stata Users,

Please help me with the following issue. I need to extend the following data set based on firm (“gvkey”) and event_date data for +3 -3 years. For example, for gvkey = 025342 (event_date = 2002) and gvkey = 146171 (event_date = 2016) I would expect something like this:
gvkey fyear t_sample event_date
25342 1998 0 1999
25342 1999 0 2000
25342 2000 0 2001
25342 2001 0 2002
25342 2002 0 2003
25342 2003 0 2004
25342 2004 0 2005
146171 2012 1 2013
146171 2013 1 2014
146171 2014 1 2015
146171 2015 1 2016
146171 2016 1 2017
146171 2017 1 2018
146171 2018 1 2019
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 gvkey double fyear float(t_sample event_date)
"025342" 2001 0 2002
"062977" 2001 0 2002
"133726" 2003 0 2004
"125014" 2007 0 2008
"177225" 2013 0 2014
"061550" 2002 0 2003
"013704" 2003 0 2004
"131423" 2002 0 2003
"108692" 2008 0 2009
"030688" 2006 0 2007
"148390" 2009 0 2010
"157755" 2014 0 2015
"132599" 2004 0 2005
"025234" 2002 0 2003
"004066" 2004 0 2005
"030451" 2001 0 2002
"065406" 2011 0 2012
"063004" 2001 0 2002
"006461" 2005 0 2006
"184604" 2013 0 2014
"145911" 2002 0 2003
"013092" 2004 0 2005
"189491" 2011 0 2012
"025013" 2006 0 2007
"160232" 2005 0 2006
"009459" 2003 0 2004
"066050" 2005 0 2006
"062317" 2007 0 2008
"133525" 2004 0 2005
"101020" 2008 0 2009
"008288" 2002 0 2003
"066698" 2002 0 2003
"016401" 2015 0 2016
"062874" 2003 0 2004
"012215" 2006 0 2007
"063483" 2007 0 2008
"183022" 2014 0 2015
"146137" 2014 0 2015
"025375" 2002 0 2003
"064747" 2004 0 2005
"062686" 2004 0 2005
"025283" 2005 0 2006
"023774" 2004 0 2005
"025773" 2001 0 2002
"028347" 2005 0 2006
"030925" 2003 0 2004
"062261" 2004 0 2005
"027938" 2002 0 2003
"141076" 2003 0 2004
"031738" 2002 0 2003
"146171" 2015 1 2016
"063054" 2003 1 2004
"030760" 2001 1 2002
"002950" 2002 1 2003
"008687" 2003 1 2004
"030843" 2003 1 2004
"063052" 2002 1 2003
"025676" 2004 1 2005
"029085" 2001 1 2002
"062036" 2004 1 2005
"155394" 2009 1 2010
"066530" 2004 1 2005
"003776" 2001 1 2002
"004675" 2003 1 2004
"122741" 2002 1 2003
"008030" 2007 1 2008
"141007" 2001 1 2002
"016531" 2003 1 2004
"064061" 2001 1 2002
"065244" 2002 1 2003
"009772" 2004 1 2005
"024113" 2012 1 2013
"110039" 2007 1 2008
"134447" 2001 1 2002
"021777" 2001 1 2002
"177111" 2007 1 2008
"004477" 2003 1 2004
"065718" 2003 1 2004
"140759" 2001 1 2002
"005520" 2003 1 2004
"029709" 2001 1 2002
"142811" 2001 1 2002
"012944" 2003 1 2004
"013599" 2008 1 2009
"065474" 2003 1 2004
"061600" 2007 1 2008
"022632" 2006 1 2007
"014353" 2004 1 2005
"121077" 2001 1 2002
"065469" 2001 1 2002
"264265" 2005 1 2006
"186342" 2011 1 2012
"025844" 2002 1 2003
"014503" 2009 1 2010
"007506" 2001 1 2002
"066447" 2001 1 2002
"008479" 2003 1 2004
"138123" 2002 1 2003
"150139" 2003 1 2004
"011805" 2001 1 2002
end