请问stata中如何根据公司id和月份得到每个公司年度账面杠杆率

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int MID函数年度 long(MID函数月度 MID股票代码) double 账面杠杆率
   
4. 2015 201501 1 16.9198806968817
   
5. 2015 201502 1 16.9198806968817
   
6. 2015 201503 1 16.6970270868811
   
7. 2015 201504 1  16.859601767322
   
8. 2015 201505 1  16.859601767322
   
9. 2015 201506 1  16.859601767322
   
10. 2015 201507 1  16.859601767322
    
11. 2015 201508 1 17.0367709437963
    
12. 2015 201509 1 17.0367709437963
    
13. 2015 201510 1 16.5401944812137
    
14. 2015 201511 1 16.5401944812137
    
15. 2015 201512 1 16.5401944812137
    
16. 2016 201601 1 16.5401944812137
    
17. 2016 201602 1 16.5401944812137
    
18. 2016 201603 1 15.5241424148606
    
19. 2016 201604 1 14.2942330555688
    
20. 2016 201605 1 14.2942330555688
    
21. 2016 201606 1 14.2942330555688
    
22. 2016 201607 1 14.2942330555688
    
23. 2016 201608 1  14.611283255086
    
24. 2016 201609 1  14.611283255086
    
25. 2016 201610 1 14.0809471921222
    
26. 2016 201611 1 14.0809471921222
    
27. 2016 201612 1 14.0809471921222
    
28. 2017 201701 1 14.0809471921222
    
29. 2017 201702 1 14.0809471921222
    
30. 2017 201703 1 14.6085937152212
    
31. 2017 201704 1 14.4710189227829
    
32. 2017 201705 1 14.4710189227829
    
33. 2017 201706 1 14.4710189227829
    
34. 2017 201707 1 14.4710189227829
    
35. 2017 201708 1  14.623237205255
    
36. 2017 201709 1  14.623237205255
    
37. 2017 201710 1 14.3847903131891
    
38. 2017 201711 1 14.3847903131891
    
39. 2017 201712 1 14.3847903131891
    
40. 2018 201801 1 14.3847903131891
    
41. 2018 201802 1 14.3847903131891
    
42. 2018 201803 1 14.6292073099336
    
43. 2018 201804 1 14.9449709254177
    
44. 2018 201805 1 14.9449709254177
    
45. 2018 201806 1 14.9449709254177
    
46. 2018 201807 1 14.9449709254177
    
47. 2018 201808 1 14.7601658623395
    
48. 2018 201809 1 14.7601658623395
    
49. 2018 201810 1 14.2500605787502
    
50. 2018 201811 1 14.2500605787502
    
51. 2018 201812 1 14.2500605787502
    
52. 2019 201901 1 14.2500605787502
    
53. 2019 201902 1 14.2500605787502
    
54. 2019 201903 1 14.2416410461502
    
55. 2019 201904 1 14.0679371000007
    
56. 2019 201905 1 14.0679371000007
    
57. 2019 201906 1 14.0679371000007
    
58. 2019 201907 1 14.0679371000007
    
59. 2019 201908 1 13.9934685097212
    
60. 2019 201909 1 13.9934685097212
    
61. 2019 201910 1 12.8706369566047
    
62. 2019 201911 1 12.8706369566047
    
63. 2019 201912 1 12.8706369566047
    
64. 2020 202001 1 12.8706369566047
    
65. 2020 202002 1 12.5855717403181
    
66. 2020 202003 1 12.5855717403181
    
67. 2020 202004 1 11.7276553475897
    
68. 2020 202005 1 11.7276553475897
    
69. 2020 202006 1 11.7276553475897
    
70. 2020 202007 1 11.7276553475897
    
71. 2020 202008 1 11.8914561023571
    
72. 2020 202009 1 11.8914561023571
    
73. 2020 202010 1  12.116143723991
    
74. 2020 202011 1  12.116143723991
    
75. 2020 202012 1  12.116143723991
    
76. 2021 202101 1  12.116143723991
    
77. 2021 202102 1 12.2717208916571
    
78. 2021 202103 1 12.2717208916571
    
79. 2021 202104 1 12.2725855234731
    
80. 2021 202105 1 12.2725855234731
    
81. 2021 202106 1 12.2725855234731
    
82. 2021 202107 1 12.2725855234731
    
83. 2021 202108 1 12.5228198826595
    
84. 2021 202109 1 12.5228198826595
    
85. 2021 202110 1 12.4803244371981
    
86. 2021 202111 1 12.4803244371981
    
87. 2021 202112 1 12.4803244371981
    
88. 2022 202201 1 12.4803244371981
    
89. 2022 202202 1 12.4803244371981
    
90. 2022 202203 1 12.4450749529647
    
91. 2022 202204 1 12.6003545269895
    
92. 2022 202205 1 12.6003545269895
    
93. 2022 202206 1 12.6003545269895
    
94. 2022 202207 1 12.6003545269895
    
95. 2022 202208 1 12.3969929482792
    
96. 2022 202209 1 12.3969929482792
    
97. 2022 202210 1 12.2128077219641
    
98. 2022 202211 1 12.2128077219641
    
99. 2022 202212 1 12.2128077219641
    
100. 2023 202301 1 12.2128077219641
     
101. 2015 201501 2 6.62138731649622
     
102. 2015 201502 2 6.62138731649622
     
103. 2015 201503 2 5.76658805162199
     
104. end

复制代码

各位好，如题，楼主想得到以公司id为序的年度均账面杠杆率。
例如（如程序可识别年份，尽可能做到2015年-2022年即可）

id	年份	账面杠杆率
1	2015	16.81
	2016	14.77
	2017	14.42
	2018	14.62
	2019	13.80
	2020	12.09
	2021	12.35
	2022	12.44
2	2015	6.19
	2016	6.86
	2017	8.02
	2018	9.41
	2019	9.89
	2020	9.25
	2021	8.63
	2022	8.10

谢谢各位！

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：Stata tata 杠杆率 generated generate

试试

1. collapse 账面杠杆率, by(MID股票代码 MID函数年度)

复制代码

谢谢大神，感激不尽！