stata新手像各位大神求助，如何按规律进行编号排序

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

我想要的结果是这样的：按照高管团队的年龄大小进行编号排序，比如在000002的企业中，在2010年有6位高管在高管团队中，则在团队中年龄最大的高管赋值为1，而年龄最小的高管赋值为6，以此类推。。。，，，

   例如：   股票代码              年份           年龄        组内排名
                ******               2010              59            1
                ******               2010              58            2
                ******               2010              57            3
                ******               2010              56            4
                ******               2010              55            5
                ******               2010              54            6

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：stata新手 Stata tata 股票代码 最大的 stata面板中 STATA问题 stata运用 stata数据处理 stata编程

想问下，这指令该怎么整，求助各位大佬。祝你们生活愉悦，乐享幸福！！

1. 你是每个股票，每年 (这个要讲清楚) 都要做排序吧？2. 若又同年龄要如何处理？3. 最重要的，若要问程序，建议永远用 (ssc install) dataex 附上相关`代表性’资料 (请尽量不要用截图或其他格式)。请参考说明 https://bbs.pinggu.org/thread-5048204-1-1.html 或https://zhuanlan.zhihu.com/p/29911577。

哞哞先森 发表于 2020-12-4 23:38
想问下，这指令该怎么整，求助各位大佬。祝你们生活愉悦，乐享幸福！！

请至少附上两个股票，两年之资料。

多谢老师提醒，我补充下我的想要结果示例。图片最右边的组内排名就是我想要的样子，按照高管年龄大小进行编号排序。


求助各位大神，老师。。

哞哞先森 发表于 2020-12-5 10:05
多谢老师提醒，我补充下我的想要结果示例。图片最右边的组内排名就是我想要的样子，按照高管年龄大小进行编 ...

补充第二张图

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 证券代码 str10 统计截止日期 str8 人员ID str54 姓名 str3 年龄 str1(是否高管团队成员 高管职务类别) float total_num
   
4. "000002" "2006-12-31" "3054222"  "肖莉"    "42" "1" "4"  9
   
5. "000002" "2006-12-31" "3043528"  "解冻"    "41" "1" "4"  9
   
6. "000002" "2006-12-31" "3053716"  "郁亮"    "41" "1" "1"  9
   
7. "000002" "2006-12-31" "30156222" "王文金" "40" "1" "2"  9
   
8. "000002" "2006-12-31" "30156346" "莫军"    "39" "1" "4"  9
   
9. "000002" "2006-12-31" "30142574" "张纪文" "39" "1" "4"  9
   
10. "000002" "2006-12-31" "30156240" "刘爱明" "37" "1" "4"  9
    
11. "000002" "2006-12-31" "309304"   "丁长峰" "36" "1" "4"  9
    
12. "000002" "2006-12-31" "3038744"  "徐洪舸" "35" "1" "4"  9
    
13. "000002" "2007-12-31" "3054222"  "肖莉"    "43" "1" "4"  9
    
14. "000002" "2007-12-31" "3053716"  "郁亮"    "42" "1" "1"  9
    
15. "000002" "2007-12-31" "3043528"  "解冻"    "42" "1" "4"  9
    
16. "000002" "2007-12-31" "30156222" "王文金" "41" "1" "4"  9
    
17. "000002" "2007-12-31" "30156346" "莫军"    "40" "1" "4"  9
    
18. "000002" "2007-12-31" "30142574" "张纪文" "40" "1" "4"  9
    
19. "000002" "2007-12-31" "30156240" "刘爱明" "38" "1" "4"  9
    
20. "000002" "2007-12-31" "309304"   "丁长峰" "37" "1" "4"  9
    
21. "000002" "2007-12-31" "3038744"  "徐洪舸" "36" "1" "4"  9
    
22. "000002" "2008-12-31" "3054222"  "肖莉"    "44" "1" "4"  9
    
23. "000002" "2008-12-31" "3043528"  "解冻"    "43" "1" "4"  9
    
24. "000002" "2008-12-31" "3053716"  "郁亮"    "43" "1" "1"  9
    
25. "000002" "2008-12-31" "30156222" "王文金" "42" "1" "4"  9
    
26. "000002" "2008-12-31" "30156346" "莫军"    "41" "1" "4"  9
    
27. "000002" "2008-12-31" "30142574" "张纪文" "41" "1" "4"  9
    
28. "000002" "2008-12-31" "30156240" "刘爱明" "39" "1" "4"  9
    
29. "000002" "2008-12-31" "309304"   "丁长峰" "38" "1" "4"  9
    
30. "000002" "2008-12-31" "3038744"  "徐洪舸" "37" "1" "4"  9
    
31. "000002" "2009-12-31" "3054222"  "肖莉"    "45" "1" "4" 10
    
32. "000002" "2009-12-31" "3053716"  "郁亮"    "44" "1" "1" 10
    
33. "000002" "2009-12-31" "3043528"  "解冻"    "44" "1" "4" 10
    
34. "000002" "2009-12-31" "30156222" "王文金" "43" "1" "4" 10
    
35. "000002" "2009-12-31" "30142574" "张纪文" "42" "1" "4" 10
    
36. "000002" "2009-12-31" "30156346" "莫军"    "42" "1" "4" 10
    
37. "000002" "2009-12-31" "30156240" "刘爱明" "40" "1" "4" 10
    
38. "000002" "2009-12-31" "309304"   "丁长峰" "39" "1" "4" 10
    
39. "000002" "2009-12-31" "3038744"  "徐洪舸" "38" "1" "4" 10
    
40. "000002" "2009-12-31" "30130814" "谭华杰" "37" "1" "4" 10
    
41. "000002" "2010-12-31" "3054222"  "肖莉"    "46" "1" "4" 10
    
42. "000002" "2010-12-31" "3053716"  "郁亮"    "45" "1" "1" 10
    
43. "000002" "2010-12-31" "3043528"  "解冻"    "45" "1" "4" 10
    
44. "000002" "2010-12-31" "30156222" "王文金" "44" "1" "4" 10
    
45. "000002" "2010-12-31" "30156346" "莫军"    "43" "1" "4" 10
    
46. "000002" "2010-12-31" "30142574" "张纪文" "43" "1" "4" 10
    
47. "000002" "2010-12-31" "30156240" "刘爱明" "41" "1" "4" 10
    
48. "000002" "2010-12-31" "309304"   "丁长峰" "40" "1" "4" 10
    
49. "000002" "2010-12-31" "3038744"  "徐洪舸" "39" "1" "4" 10
    
50. "000002" "2010-12-31" "30130814" "谭华杰" "38" "1" "4" 10
    
51. "000002" "2011-12-31" "3044616"  "周卫军" "56" "1" "4" 11
    
52. "000002" "2011-12-31" "3054222"  "肖莉"    "47" "1" "4" 11
    
53. "000002" "2011-12-31" "3053716"  "郁亮"    "46" "1" "1" 11
    
54. "000002" "2011-12-31" "3043528"  "解冻"    "46" "1" "4" 11
    
55. "000002" "2011-12-31" "30156222" "王文金" "45" "1" "4" 11
    
56. "000002" "2011-12-31" "30142574" "张纪文" "44" "1" "4" 11
    
57. "000002" "2011-12-31" "30156346" "莫军"    "44" "1" "4" 11
    
58. "000002" "2011-12-31" "3052888"  "毛大庆" "43" "1" "4" 11
    
59. "000002" "2011-12-31" "309304"   "丁长峰" "41" "1" "4" 11
    
60. "000002" "2011-12-31" "30151046" "杜晶"    "41" "1" "4" 11
    
61. "000002" "2011-12-31" "30130814" "谭华杰" "39" "1" "4" 11
    
62. "000002" "2012-12-31" "3044616"  "周卫军" "57" "1" "4" 11
    
63. "000002" "2012-12-31" "3054222"  "肖莉"    "49" "1" "4" 11
    
64. "000002" "2012-12-31" "3053716"  "郁亮"    "48" "1" "1" 11
    
65. "000002" "2012-12-31" "3043528"  "解冻"    "47" "1" "4" 11
    
66. "000002" "2012-12-31" "30156222" "王文金" "47" "1" "4" 11
    
67. "000002" "2012-12-31" "30156346" "莫军"    "46" "1" "4" 11
    
68. "000002" "2012-12-31" "30142574" "张纪文" "46" "1" "4" 11
    
69. "000002" "2012-12-31" "3052888"  "毛大庆" "44" "1" "4" 11
    
70. "000002" "2012-12-31" "309304"   "丁长峰" "42" "1" "4" 11
    
71. "000002" "2012-12-31" "30151046" "杜晶"    "42" "1" "4" 11
    
72. "000002" "2012-12-31" "30130814" "谭华杰" "40" "1" "4" 11
    
73. "000002" "2013-12-31" "3044616"  "周卫军" "58" "1" "4" 10
    
74. "000002" "2013-12-31" "3054222"  "肖莉"    "50" "1" "4" 10
    
75. "000002" "2013-12-31" "3053716"  "郁亮"    "49" "1" "1" 10
    
76. "000002" "2013-12-31" "3043528"  "解冻"    "48" "1" "4" 10
    
77. "000002" "2013-12-31" "30156222" "王文金" "48" "1" "4" 10
    
78. "000002" "2013-12-31" "30142574" "张纪文" "47" "1" "4" 10
    
79. "000002" "2013-12-31" "30156346" "莫军"    "47" "1" "4" 10
    
80. "000002" "2013-12-31" "3052888"  "毛大庆" "45" "1" "4" 10
    
81. "000002" "2013-12-31" "309304"   "丁长峰" "43" "1" "4" 10
    
82. "000002" "2013-12-31" "30130814" "谭华杰" "41" "1" "4" 10
    
83. "000002" "2014-12-31" "3044616"  "周卫军" "59" "1" "4" 11
    
84. "000002" "2014-12-31" "30279602" "陈玮"    "53" "1" "4" 11
    
85. "000002" "2014-12-31" "30287416" "张旭"    "51" "1" "4" 11
    
86. "000002" "2014-12-31" "3054222"  "肖莉"    "51" "1" "4" 11
    
87. "000002" "2014-12-31" "3053716"  "郁亮"    "50" "1" "1" 11
    
88. "000002" "2014-12-31" "30156222" "王文金" "49" "1" "4" 11
    
89. "000002" "2014-12-31" "30142574" "张纪文" "48" "1" "4" 11
    
90. "000002" "2014-12-31" "30156346" "莫军"    "48" "1" "4" 11
    
91. "000002" "2014-12-31" "3052888"  "毛大庆" "46" "1" "4" 11
    
92. "000002" "2014-12-31" "309304"   "丁长峰" "44" "1" "4" 11
    
93. "000002" "2014-12-31" "30130814" "谭华杰" "42" "1" "4" 11
    
94. "000002" "2015-12-31" "30279602" "陈玮"    "54" "1" "4"  5
    
95. "000002" "2015-12-31" "30287416" "张旭"    "53" "1" "4"  5
    
96. "000002" "2015-12-31" "3053716"  "郁亮"    "51" "1" "1"  5
    
97. "000002" "2015-12-31" "30156222" "王文金" "50" "1" "4"  5
    
98. "000002" "2015-12-31" "30130814" "谭华杰" "43" "1" "4"  5
    
99. "000002" "2016-12-31" "30279602" "陈玮"    "55" "1" "4"  7
    
100. "000002" "2016-12-31" "30287416" "张旭"    "54" "1" "4"  7
     
101. "000002" "2016-12-31" "3053716"  "郁亮"    "52" "1" "1"  7
     
102. "000002" "2016-12-31" "30156222" "王文金" "51" "1" "4"  7
     
103. "000002" "2016-12-31" "30130814" "谭华杰" "44" "1" "4"  7
     
104. end

复制代码

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 证券代码 str10 统计截止日期 str8 人员ID str54 姓名 str3 年龄 str1(是否高管团队成员 高管职务类别) float total_num
   
4. "000004" "2006-12-31" "3077184"  "王克昕" "42" "1" "1" 3
   
5. "000004" "2006-12-31" "30614"    "郭景军" "42" "1" "2" 3
   
6. "000004" "2006-12-31" "3070216"  "蒋伟诚" "36" "1" "4" 3
   
7. "000004" "2007-12-31" "3075086"  "王鲁锋" "56" "1" "1" 6
   
8. "000004" "2007-12-31" "3084106"  "王金水" "52" "1" "4" 6
   
9. "000004" "2007-12-31" "301862"   "南国良" "51" "1" "4" 6
   
10. "000004" "2007-12-31" "3092872"  "唐先华" "44" "1" "2" 6
    
11. "000004" "2007-12-31" "3077184"  "王克昕" "43" "1" "1" 6
    
12. "000004" "2007-12-31" "3070216"  "蒋伟诚" "37" "1" "4" 6
    
13. "000004" "2008-12-31" "3075086"  "王鲁锋" "57" "1" "1" 6
    
14. "000004" "2008-12-31" "3084106"  "王金水" "53" "1" "4" 6
    
15. "000004" "2008-12-31" "301862"   "南国良" "52" "1" "4" 6
    
16. "000004" "2008-12-31" "3092872"  "唐先华" "45" "1" "2" 6
    
17. "000004" "2008-12-31" "3077184"  "王克昕" "44" "1" "1" 6
    
18. "000004" "2008-12-31" "3070216"  "蒋伟诚" "38" "1" "4" 6
    
19. "000004" "2009-12-31" "3075086"  "王鲁锋" "58" "1" "1" 6
    
20. "000004" "2009-12-31" "3084106"  "王金水" "54" "1" "4" 6
    
21. "000004" "2009-12-31" "301862"   "南国良" "53" "1" "4" 6
    
22. "000004" "2009-12-31" "3092872"  "唐先华" "46" "1" "2" 6
    
23. "000004" "2009-12-31" "3087394"  "罗晓"    "44" "1" "1" 6
    
24. "000004" "2009-12-31" "3070216"  "蒋伟诚" "39" "1" "4" 6
    
25. "000004" "2010-12-31" "3075086"  "王鲁锋" "59" "1" "1" 8
    
26. "000004" "2010-12-31" "3084106"  "王金水" "55" "1" "4" 8
    
27. "000004" "2010-12-31" "301862"   "南国良" "54" "1" "4" 8
    
28. "000004" "2010-12-31" "3092872"  "唐先华" "47" "1" "2" 8
    
29. "000004" "2010-12-31" "3087394"  "罗晓"    "45" "1" "1" 8
    
30. "000004" "2010-12-31" "30138572" "张新凯" "41" "1" "1" 8
    
31. "000004" "2010-12-31" "3070216"  "蒋伟诚" "40" "1" "4" 8
    
32. "000004" "2010-12-31" "3044766"  "杨斌"    "38" "1" "4" 8
    
33. "000004" "2011-12-31" "3084106"  "王金水" "56" "1" "4" 6
    
34. "000004" "2011-12-31" "3092872"  "唐先华" "48" "1" "2" 6
    
35. "000004" "2011-12-31" "3087394"  "罗晓"    "46" "1" "1" 6
    
36. "000004" "2011-12-31" "30138572" "张新凯" "42" "1" "1" 6
    
37. "000004" "2011-12-31" "3070216"  "蒋伟诚" "41" "1" "4" 6
    
38. "000004" "2011-12-31" "3044766"  "杨斌"    "39" "1" "4" 6
    
39. "000004" "2012-12-31" "3084106"  "王金水" "57" "1" "4" 6
    
40. "000004" "2012-12-31" "30194586" "郑起平" "50" "1" "4" 6
    
41. "000004" "2012-12-31" "3092872"  "唐先华" "49" "1" "2" 6
    
42. "000004" "2012-12-31" "3070216"  "蒋伟诚" "43" "1" "4" 6
    
43. "000004" "2012-12-31" "30138572" "张新凯" "43" "1" "1" 6
    
44. "000004" "2012-12-31" "3044766"  "杨斌"    "40" "1" "4" 6
    
45. "000004" "2013-12-31" "3084106"  "王金水" "58" "1" "4" 9
    
46. "000004" "2013-12-31" "30194586" "郑起平" "51" "1" "4" 9
    
47. "000004" "2013-12-31" "3092872"  "唐先华" "50" "1" "2" 9
    
48. "000004" "2013-12-31" "30257433" "陈奕璇" "46" "1" "4" 9
    
49. "000004" "2013-12-31" "30138572" "张新凯" "44" "1" "1" 9
    
50. "000004" "2013-12-31" "3070216"  "蒋伟诚" "44" "1" "4" 9
    
51. "000004" "2013-12-31" "3044766"  "杨斌"    "41" "1" "4" 9
    
52. "000004" "2013-12-31" "30257427" "徐文苏" "37" "1" "2" 9
    
53. "000004" "2013-12-31" "30257424" "李林琳" "30" "1" "1" 9
    
54. "000004" "2014-12-31" "30257433" "陈奕璇" "47" "1" "4" 4
    
55. "000004" "2014-12-31" "3044766"  "杨斌"    "42" "1" "4" 4
    
56. "000004" "2014-12-31" "30257427" "徐文苏" "38" "1" "2" 4
    
57. "000004" "2014-12-31" "30257424" "李林琳" "31" "1" "1" 4
    
58. "000004" "2015-12-31" "30257433" "陈奕璇" "48" "1" "4" 4
    
59. "000004" "2015-12-31" "3044766"  "杨斌"    "43" "1" "4" 4
    
60. "000004" "2015-12-31" "30257427" "徐文苏" "39" "1" "2" 4
    
61. "000004" "2015-12-31" "30257424" "李林琳" "32" "1" "1" 4
    
62. "000004" "2016-12-31" "30344026" "黄翔"    "51" "1" "4" 3
    
63. "000004" "2016-12-31" "30257427" "徐文苏" "40" "1" "2" 3
    
64. "000004" "2016-12-31" "30257424" "李林琳" "33" "1" "1" 3
    
65. "000004" "2017-12-31" "30344026" "黄翔"    "52" "1" "4" 4
    
66. "000004" "2017-12-31" "30257427" "徐文苏" "41" "1" "2" 4
    
67. "000004" "2017-12-31" "30257424" "李林琳" "34" "1" "1" 4
    
68. "000004" "2017-12-31" "30361933" "阮旭里" "27" "1" "4" 4
    
69. "000004" "2018-12-31" "30344026" "黄翔"    "53" "1" "1" 5
    
70. "000004" "2018-12-31" "30257427" "徐文苏" "42" "1" "2" 5
    
71. "000004" "2018-12-31" "30257424" "李林琳" "35" "1" "1" 5
    
72. "000004" "2018-12-31" "30432876" "李琛森" "31" "1" "4" 5
    
73. "000004" "2018-12-31" "30361933" "阮旭里" "28" "1" "4" 5
    
74. "000004" "2019-12-31" "30344026" "黄翔"    "54" "1" "1" 6
    
75. "000004" "2019-12-31" "30257427" "徐文苏" "43" "1" "2" 6
    
76. "000004" "2019-12-31" "30438344" "陈金海" "41" "1" "2" 6
    
77. "000004" "2019-12-31" "30257424" "李林琳" "36" "1" "1" 6
    
78. "000004" "2019-12-31" "30432876" "李琛森" "32" "1" "4" 6
    
79. "000004" "2019-12-31" "30361933" "阮旭里" "29" "1" "4" 6
    
80. end

复制代码

就想要，每个企业每一年度，都要做排序，就像total_num，已经计算出了当年该股票代码的高管总人数，我想进行编号排序，年龄最大的是1，年龄第二大的是2，。。。年龄最小的是当年高管总人数，例如
str6 证券代码 str10 统计截止日期 str8 人员ID str54 姓名 str3 年龄 str1(是否高管团队成员 高管职务类别) float total_num
"000002" "2006-12-31" "3054222"  "肖莉"    "42" "1" "4"  9

在000002中，2006年，当年高管总人数为9名，则高管年龄最大的是1，第二大的是2，第三大的是3，。。。年龄最小的是9.
就这样为高管的年龄进行编号排序。

求助各位老师了