谢谢黄河泉老师指点,按照您的建议,我把数据的部分资料示例如下:inve3是投资数据,spike是投资高峰,文献里的定义是 An indicator equal to one in years when a firm’s Investment exceeds two times its
median Investment 。Spell Lengthit :文献里的定义是 The current year minus the year of the firm’s last investment spike,应该是当前年份减去企业上一次投资高峰的年份吧, 不知理解的是否正确,请问老师Spell Lengthit 在Stata里如何计算?
* Example generated by -dataex-. To install: ssc install dataex
clear
input long code int year double(inve3 spike)
2 2000 .011212207889467666 1
2 2001 .004652664322401818 0
2 2002 .0063057824872456165 1
2 2003 .003929370970468741 0
2 2004 .0021902371095429227 0
2 2005 .002157089236485528 0
2 2006 .00280404201049823 0
2 2007 .0025765438461223937 0
2 2008 .0018055175281241453 0
2 2009 .005857645680091422 1
2 2010 .001214716774069126 0
2 2011 .000883029842004046 0
2 2012 .00039774813684472204 0
2 2013 .0050904941091668736 0
2 2014 .0036009324302514667 0
2 2015 .0033748017269586757 0
2 2016 .002584389329396051 0
2 2017 .002025560938915098 0
4 2000 .027700292071658875 0
4 2001 .035246372446361925 0
4 2002 .022780405552736704 0
4 2003 .01775822776250611 0
4 2006 .009510167325045489 0
4 2009 .006243714789496335 0
4 2010 .12440163880059046 1
4 2011 .03739443633018239 0
4 2012 .09511299375377695 1
4 2013 .008926191397906697 0
4 2014 .03314476897651029 0
4 2015 .010371283584058222 0
4 2016 .010034764879193006 0
4 2017 .02174902999552444 0
5 2006 .0006019977669674259 0
5 2007 .0008470770404338991 0
5 2008 .004311784985972088 0
5 2011 .007327270066669626 0
5 2012 .01432647805443116 1
5 2013 .008980868845271842 0
5 2014 .21303528572685007 1
5 2016 .0061001127192159945 0
5 2017 .006625881166223293 0
6 2000 .012802010792224068 1
6 2001 .08606658218795088 1
6 2002 .0755770433061105 1
6 2004 .0030340841144267 1
6 2005 .01762134072401256 1
6 2006 .25411283184605 1
6 2007 .0010882708206108927 0
6 2008 .002493299631683462 1
6 2009 .0008146183401212614 0
end