- [CODE]
- * Example generated by -dataex-. To install: ssc install dataex
- clear
- input long id int year str59 sjs
- 1 1992 "曹明达"
- 1 1993 "李国志,袁凤仪"
- 1 1994 "刘祥青,李国志"
- 1 1995 "刘祥青,李国志"
- 1 1996 "李国志,赖文建"
- 1 1997 "陈勤慧,侯立勋"
- 1 1998 "侯立勋,陈勤慧"
- 1 1999 "赖文建,侯立勋"
- 1 2000 "张克理,梁烽"
- 1 2001 "侯立勋,陈爱容"
- 1 2002 "侯立勋,陈爱容"
- 1 2003 "侯立勋,陈爱容"
- 1 2004 "杨克晶,陈爱容"
- 1 2005 "龙英,杨克晶"
- 1 2006 "龙英,侯立勋"
- 1 2007 "张小东,许旭明"
- 1 2008 "张小东,许旭明"
- 1 2009 "张小东,许旭明"
- 1 2010 "张小东,昌华"
- 1 2011 "张小东,昌华"
- 1 2012 "昌华,周道君"
- 1 2013 "姚文平,朱丽平"
- 1 2014 "姚文平,朱丽平"
- 1 2015 "姚文平,朱丽平"
- 1 2016 "姚文平,甘莉莉"
- 1 2017 "姚文平,甘莉莉"
- 2 1992 "王珍亭,候德彰"
- 2 1993 "候德彰,王珍亭"
- 2 1994 "付刚峰,侯德彰"
- 2 1995 "王珍亭,侯德彰"
- 2 1996 "许丽周,李莉"
- 2 1997 "许丽周,李莉"
- 2 1998 "许丽周,李莉"
- 2 1999 "许丽周,李莉"
- 2 2000 "许丽周,李莉"
- 2 2001 "赵奇,金乃雯"
- 2 2002 "赵奇,罗科"
- 2 2003 "罗科,金乃雯"
- 2 2004 "罗科,彭菁"
- 2 2005 "李婉薇,彭菁"
- 2 2006 "李婉薇,彭菁"
- 2 2007 ""
- 2 2008 "彭菁,杨辰"
- 2 2009 "李嘉琪,李婉薇"
- 2 2010 "李婉薇,李灼光"
- 2 2011 "李婉薇,温华新"
- 2 2012 "李婉薇,温华新"
- 2 2013 "李婉薇,温华新"
- 2 2014 "王晓梅,罗永辉"
- 2 2015 "王晓梅,罗永辉"
- end
[/code]
想要得到的结果:知道每个公司每年人名连续出现的次数。
举例:id为2 的1992年 "王珍亭“,”候德彰"各出现1次;
1993年"王珍亭“,”候德彰"各连续出现2次;
1994年,"付刚峰“出现1次,”侯德彰"连续出现3次;
1995年"王珍亭“出现1次,而”侯德彰”连续出现4次。
请问这个怎么用stata实现?谢谢!!