Alice_1i 发表于 2020-11-8 11:55 
bysort id enddate year : gen event=_N
replace event=0 if event!=1
谢谢。我好像没讲清楚。我想给每个id生成一个新变量wot,每个id的event有2004-2010年取值,只要这7年中有一个event取值不为空,wot就取1。想要的结果如下
id enddate event year wot
002012 2004-12-31 2004 1
002012 2005-12-31 2005 1
002012 2006-12-31 2006 1
002012 2007-12-31 1 2007 1
002012 2008-12-31 1 2008 1
002012 2009-12-31 2009 1
002012 2010-12-31 2010 1
002013 2004-12-31 1 2004 1
002013 2005-12-31 1 2005 1
002013 2006-12-31 2006 1
002013 2007-12-31 1 2007 1
002013 2008-12-31 1 2008 1
002013 2009-12-31 1 2009 1
002013 2010-12-31 2010 1
002014 2004-12-31 2004 0
002014 2005-12-31 2005 0
002014 2006-12-31 2006 0
002014 2007-12-31 2007 0
002014 2008-12-31 2008 0
002014 2009-12-31 2009 0
002014 2010-12-31 2010 0