[面板数据求助] 请问stata中如何根据公司id和月份得到每个公司年度均账面杠杆率 [推广有奖]

0关注
0粉丝

初中生

4%

还不是VIP/贵宾

-

0%

威望: 0 级
论坛币: 0 个
通用积分: 0
学术水平: 0 点
热心指数: 0 点
信用等级: 0 点
经验: 113 点
帖子: 4
精华: 0
在线时间: 12 小时
注册时间: 2022-9-18
最后登录: 2023-4-27

楼主

Gobinet- 发表于 2023-4-7 21:02:07 |AI写论文

10论坛币

* Example generated by -dataex-. To install: ssc install dataex
clear
input int MID函数年度 long(MID函数月度 MID股票代码) double 账面杠杆率
2015 201501 1 16.9198806968817
2015 201502 1 16.9198806968817
2015 201503 1 16.6970270868811
2015 201504 1 16.859601767322
2015 201505 1 16.859601767322
2015 201506 1 16.859601767322
2015 201507 1 16.859601767322
2015 201508 1 17.0367709437963
2015 201509 1 17.0367709437963
2015 201510 1 16.5401944812137
2015 201511 1 16.5401944812137
2015 201512 1 16.5401944812137
2016 201601 1 16.5401944812137
2016 201602 1 16.5401944812137
2016 201603 1 15.5241424148606
2016 201604 1 14.2942330555688
2016 201605 1 14.2942330555688
2016 201606 1 14.2942330555688
2016 201607 1 14.2942330555688
2016 201608 1 14.611283255086
2016 201609 1 14.611283255086
2016 201610 1 14.0809471921222
2016 201611 1 14.0809471921222
2016 201612 1 14.0809471921222
2017 201701 1 14.0809471921222
2017 201702 1 14.0809471921222
2017 201703 1 14.6085937152212
2017 201704 1 14.4710189227829
2017 201705 1 14.4710189227829
2017 201706 1 14.4710189227829
2017 201707 1 14.4710189227829
2017 201708 1 14.623237205255
2017 201709 1 14.623237205255
2017 201710 1 14.3847903131891
2017 201711 1 14.3847903131891
2017 201712 1 14.3847903131891
2018 201801 1 14.3847903131891
2018 201802 1 14.3847903131891
2018 201803 1 14.6292073099336
2018 201804 1 14.9449709254177
2018 201805 1 14.9449709254177
2018 201806 1 14.9449709254177
2018 201807 1 14.9449709254177
2018 201808 1 14.7601658623395
2018 201809 1 14.7601658623395
2018 201810 1 14.2500605787502
2018 201811 1 14.2500605787502
2018 201812 1 14.2500605787502
2019 201901 1 14.2500605787502
2019 201902 1 14.2500605787502
2019 201903 1 14.2416410461502
2019 201904 1 14.0679371000007
2019 201905 1 14.0679371000007
2019 201906 1 14.0679371000007
2019 201907 1 14.0679371000007
2019 201908 1 13.9934685097212
2019 201909 1 13.9934685097212
2019 201910 1 12.8706369566047
2019 201911 1 12.8706369566047
2019 201912 1 12.8706369566047
2020 202001 1 12.8706369566047
2020 202002 1 12.5855717403181
2020 202003 1 12.5855717403181
2020 202004 1 11.7276553475897
2020 202005 1 11.7276553475897
2020 202006 1 11.7276553475897
2020 202007 1 11.7276553475897
2020 202008 1 11.8914561023571
2020 202009 1 11.8914561023571
2020 202010 1 12.116143723991
2020 202011 1 12.116143723991
2020 202012 1 12.116143723991
2021 202101 1 12.116143723991
2021 202102 1 12.2717208916571
2021 202103 1 12.2717208916571
2021 202104 1 12.2725855234731
2021 202105 1 12.2725855234731
2021 202106 1 12.2725855234731
2021 202107 1 12.2725855234731
2021 202108 1 12.5228198826595
2021 202109 1 12.5228198826595
2021 202110 1 12.4803244371981
2021 202111 1 12.4803244371981
2021 202112 1 12.4803244371981
2022 202201 1 12.4803244371981
2022 202202 1 12.4803244371981
2022 202203 1 12.4450749529647
2022 202204 1 12.6003545269895
2022 202205 1 12.6003545269895
2022 202206 1 12.6003545269895
2022 202207 1 12.6003545269895
2022 202208 1 12.3969929482792
2022 202209 1 12.3969929482792
2022 202210 1 12.2128077219641
2022 202211 1 12.2128077219641
2022 202212 1 12.2128077219641
2023 202301 1 12.2128077219641
2015 201501 2 6.62138731649622
2015 201502 2 6.62138731649622
2015 201503 2 5.76658805162199
end

[color=rgb(51, 102, 153) !important]复制代码

各位好，如题，楼主想得到以公司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 杠杆率 IMPORTANT generated

[面板数据求助] 请问stata中如何根据公司id和月份得到每个公司年度均账面杠杆率 [推广有奖]

相关帖子

浏览过的帖子

浏览过的版块

本版微信群