求助各位老师如何将季度数据加总成年度数据

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

需要加总的是变量f110101b，麻烦各位了！数据如下所示：

1. * Example generated by -dataex-. For more info, type help dataex
   
2. clear
   
3. input str6 stkcd str10 accper float f110101b
   
4. "000001" "2000-06-30"     .
   
5. "000001" "2000-12-31"     .
   
6. "000001" "2001-06-30"     .
   
7. "000001" "2001-12-31"   .15
   
8. "000001" "2002-03-31"     .
   
9. "000001" "2002-06-30"     .
   
10. "000001" "2002-09-30"     .
    
11. "000001" "2002-12-31"   .15
    
12. "000001" "2003-03-31"     .
    
13. "000001" "2003-06-30"     .
    
14. "000001" "2003-09-30"     .
    
15. "000001" "2003-12-31"     .
    
16. "000001" "2004-03-31"     .
    
17. "000001" "2004-06-30"     .
    
18. "000001" "2004-09-30"     .
    
19. "000001" "2004-12-31"     .
    
20. "000001" "2005-03-31"     .
    
21. "000001" "2005-06-30"     .
    
22. "000001" "2005-09-30"     .
    
23. "000001" "2005-12-31"     .
    
24. "000001" "2006-03-31"     .
    
25. "000001" "2006-06-30"     .
    
26. "000001" "2006-09-30"     .
    
27. "000001" "2006-12-31"     .
    
28. "000001" "2007-03-31"     .
    
29. "000001" "2007-06-30"     .
    
30. "000001" "2007-09-30"     .
    
31. "000001" "2007-12-31"     .
    
32. "000001" "2008-03-31"     .
    
33. "000001" "2008-06-30" .0335
    
34. "000001" "2008-09-30"     .
    
35. "000001" "2008-12-31" .0335
    
36. "000001" "2009-03-31"     .
    
37. "000001" "2009-06-30"     .
    
38. "000001" "2009-09-30"     .
    
39. "000001" "2009-12-31"     .
    
40. "000001" "2010-03-31"     .
    
41. "000001" "2010-06-30"     .
    
42. "000001" "2010-09-30"     .
    
43. "000001" "2010-12-31"     .
    
44. "000001" "2011-03-31"     .
    
45. "000001" "2011-06-30"     .
    
46. "000001" "2011-09-30"     .
    
47. "000001" "2011-12-31"     .
    
48. "000001" "2012-03-31"     .
    
49. "000001" "2012-06-30"    .1
    
50. "000001" "2012-09-30"     .
    
51. "000001" "2012-12-31"   .27
    
52. "000001" "2013-03-31"     .
    
53. "000001" "2013-06-30"     .
    
54. "000001" "2013-09-30"     .
    
55. "000001" "2013-12-31"   .16
    
56. "000001" "2014-03-31"     .
    
57. "000001" "2014-06-30"     .
    
58. "000001" "2014-09-30"     .
    
59. "000001" "2014-12-31"  .174
    
60. "000001" "2015-03-31"     .
    
61. "000001" "2015-06-30"     .
    
62. "000001" "2015-09-30"     .
    
63. "000001" "2015-12-31"  .153
    
64. "000001" "2016-03-31"     .
    
65. "000001" "2016-06-30"     .
    
66. "000001" "2016-09-30"     .
    
67. "000001" "2016-12-31"  .158
    
68. "000001" "2017-03-31"     .
    
69. "000001" "2017-06-30"     .
    
70. "000001" "2017-09-30"     .
    
71. "000001" "2017-12-31"  .136
    
72. "000001" "2018-03-31"     .
    
73. "000001" "2018-06-30"     .
    
74. "000001" "2018-09-30"     .
    
75. "000001" "2018-12-31"  .145
    
76. "000001" "2019-03-31"     .
    
77. "000001" "2019-06-30"     .
    
78. "000001" "2019-09-30"     .
    
79. "000001" "2019-12-31"  .218
    
80. "000001" "2020-03-31"     .
    
81. "000001" "2020-06-30"     .
    
82. "000001" "2020-09-30"     .
    
83. "000001" "2020-12-31"   .18
    
84. "000002" "2000-06-30"     .
    
85. "000002" "2000-12-31"   .18
    
86. "000002" "2001-06-30"     .
    
87. "000002" "2001-12-31"    .2
    
88. "000002" "2002-03-31"     .
    
89. "000002" "2002-06-30"     .
    
90. "000002" "2002-09-30"     .
    
91. "000002" "2002-12-31"    .2
    
92. "000002" "2003-03-31"     .
    
93. "000002" "2003-06-30"     .
    
94. "000002" "2003-09-30"     .
    
95. "000002" "2003-12-31"   .05
    
96. "000002" "2004-03-31"     .
    
97. "000002" "2004-06-30"     .
    
98. "000002" "2004-09-30"     .
    
99. "000002" "2004-12-31"   .15
    
100. "000002" "2005-03-31"     .
     
101. "000002" "2005-06-30"     .
     
102. "000002" "2005-09-30"     .
     
103. "000002" "2005-12-31"   .15
     
104. end

复制代码

------------------ copy up to and including the previous line ------------------

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：季度数据 年度数据 including generated previous

可以用数据透视表解决

使用 collapse 函数即可