[编程问题求助] 求解决egen group不能和by连用的困惑 [推广有奖]

11楼

bwusxyrdlt 发表于 2017-12-21 18:56:22

黃河泉发表于 2017-12-21 17:12
没看到 manager 的资料，请

复制代码

[/code]

12楼

黃河泉

发表于 2017-12-22 06:55:39

bwusxyrdlt 发表于 2017-12-21 18:56
[/code]

为什么你给的资料与你的上图不一样？

13楼

黃河泉

发表于 2017-12-22 10:15:56

试试 (别人建议的)

* Example generated by -dataex-. To install: ssc install dataex
clear
input int year str12 auditorfirm float manager byte rank1
2008 "A" 0 5
2008 "A" 1 4
2008 "A" 2 3
2008 "A" 2 3
2008 "A" 2 3
2008 "A" 4 2
2008 "A" 5 1
2008 "B" 11 2
2008 "B" 21 1
2009 "A" 2 4
2009 "A" 2 4
2009 "A" 3 3
2009 "A" 4 2
2009 "A" 4 2
2009 "A" 5 1
2009 "B" 0 2
2009 "B" 1 1
end
// Clyde Schechter
by auditorfirm year manager, sort: gen rank = 1 if _n == 1
gsort auditorfirm year -manager rank
by auditorfirm year: replace rank = sum(rank)
assert rank == rank1
// Romalpa Akzo
bys year auditorfirm (manager): gen internalgroup = sum(manager != manager[_n-1])
bys year auditorfirm (manager): replace internalgroup = internalgroup[_N] + 1 - internalgroup