请问，怎么按年度按行业算出cash的平均值？

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

第一列是公司代码，第二列是年度，第三列是cash，第四列是行业代码，请问，怎么按年度，按行业算出cash的平均值呢？



----------------------- copy starting from the next line -----------------------

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input long dm int nd float cash2 byte hy
   
4. 4 2012  .41791 27
   
5. 4 2013 .311475 27
   
6. 4 2014 .133333 27
   
7. 4 2015 .149425 27
   
8. 4 2016 .774194 27
   
9. 4 2017 .588235 27
   
10. 5 2012 .010101 77
    
11. 5 2013 .009251 77
    
12. 5 2014  .01083 77
    
13. 5 2015 .062802 77
    
14. 5 2016 .015022 77
    
15. 5 2017 .017187 77
    
16. 6 2012     .24 70
    
17. 6 2013     .25 70
    
18. 6 2014 .121495 70
    
19. 6 2015 .150442 70
    
20. 6 2016 .262136 70
    
21. 6 2017 .287129 70
    
22. 7 2012 .179104 70
    
23. 7 2013 .245283 70
    
24. 7 2014 .123967 70
    
25. 7 2015 .846154 70
    
26. 7 2016 .128319 70
    
27. 7 2017 .020408 70
    
28. 8 2012     .22 37
    
29. 8 2013   .3125 37
    
30. 8 2014 .367347 37
    
31. 8 2015 .132075 37
    
32. 8 2016  .15493 37
    
33. 8 2017 .094527 37
    
34. 9 2012 .160714 90
    
35. 9 2013     .12 90
    
36. 9 2014 .145038 90
    
37. 9 2015     .25 90
    
38. 9 2016 .089109 90
    
39. 9 2017 .158798 90
    
40. 10 2012 .061947 48
    
41. 10 2013 .851852 48
    
42. 10 2014 .904762 48
    
43. 10 2015 .268293 48
    
44. 10 2016 .027254 48
    
45. 10 2017  .05802 48
    
46. 14 2012 .162791 70
    
47. 14 2013  .12426 70
    
48. 14 2014 .111111 70
    
49. 14 2015  .04712 70
    
50. 14 2016 .137725 70
    
51. 14 2017 .086957 70
    
52. 21 2012 .234568 39
    
53. 21 2013 .186441 39
    
54. 21 2014 .157025 39
    
55. 21 2015 .196581 39
    
56. 21 2016 .100917 39
    
57. 21 2017 .103896 39
    
58. 23 2012  .22449 30
    
59. 23 2013 .101695 30
    
60. 23 2014  .06082 30
    
61. 23 2015 .061712 30
    
62. 23 2016 .102941 30
    
63. 23 2017 .183432 30
    
64. 27 2012 .180812 44
    
65. 27 2013 .137931 44
    
66. 27 2014 .180124 44
    
67. 27 2015 .198347 44
    
68. 27 2016 .103074 44
    
69. 27 2017 .104735 44
    
70. 31 2012  .19863 70
    
71. 31 2013 .168091 70
    
72. 31 2014 .185567 70
    
73. 31 2015 .203501 70
    
74. 31 2016 .297872 70
    
75. 31 2017 .151515 70
    
76. 32 2012 .259259 51
    
77. 32 2013 .190476 51
    
78. 32 2014 .196581 51
    
79. 32 2015 .329114 51
    
80. 32 2016 .242236 51
    
81. 32 2017 .210191 51
    
82. 34 2012 .194969 51
    
83. 34 2013 .183801 51
    
84. 34 2014 .067285 51
    
85. 34 2015 .323529 51
    
86. 34 2016 .069182 51
    
87. 34 2017 .066667 51
    
88. 35 2012 .002655 77
    
89. 35 2013       . 77
    
90. 35 2015 .047619 77
    
91. 35 2016 .032702 77
    
92. 35 2017 .173913 77
    
93. 36 2012 .387097 70
    
94. 36 2013      .4 70
    
95. 36 2014 .050228 70
    
96. 36 2015 .226415 70
    
97. 36 2016 .405797 70
    
98. 36 2017 .175676 70
    
99. 38 2012 .026936 72
    
100. 38 2013 .028744 72
     
101. 38 2014 .054264 72
     
102. 38 2015 .171875 72
     
103. 38 2016 .488372 72
     
104. end

复制代码

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

试试

1. bys nd hy: egen cm = mean(cash)

复制代码