按年份分组，对季度数据求和问题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

如下例，有两只股票，000592和000711，现在我想要对每一只股票，按每一年求出四个季度sinc的和。

即，求出000592的2007年四个季度的sinc之和，以及2008年四个季度的sinc之和，同理求000711分别在2007年和2008年四个季度的sinc之和。

例子只是选取了两只股票和两年时间，实际上还有很多股票和年份。

请问STATA需要怎么操作呢？

stkcd	accper	type	sinc
000592	2007-03-31	A	74170.55
000592	2007-06-30	A	94760
000592	2007-09-30	A	125850
000592	2007-12-31	A	189250
000592	2008-03-31	A	50665460.73
000592	2008-06-30	A	129282793.45
000592	2008-09-30	A	212003161.3
000592	2008-12-31	A	283526011.92
000711	2007-03-31	A	1229012.8
000711	2007-06-30	A	174198106.2
000711	2007-09-30	A	184116796.19
000711	2007-12-31	A	194816688.5
000711	2008-03-31	A	12303561.67
000711	2008-06-30	A	25185210.31
000711	2008-09-30	A	39386456.05
000711	2008-12-31	A	52613373.04

dataex如下：

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 stkcd str10 accper str1 type str12 sinc
   
4. "000592" "2007-03-31" "A" "74170.55"   
   
5. "000592" "2007-06-30" "A" "94760"      
   
6. "000592" "2007-09-30" "A" "125850"      
   
7. "000592" "2007-12-31" "A" "189250"      
   
8. "000592" "2008-03-31" "A" "50665460.73"
   
9. "000592" "2008-06-30" "A" "129282793.45"
   
10. "000592" "2008-09-30" "A" "212003161.3"
    
11. "000592" "2008-12-31" "A" "283526011.92"
    
12. "000711" "2007-03-31" "A" "1229012.8"   
    
13. "000711" "2007-06-30" "A" "174198106.2"
    
14. "000711" "2007-09-30" "A" "184116796.19"
    
15. "000711" "2007-12-31" "A" "194816688.5"
    
16. "000711" "2008-03-31" "A" "12303561.67"
    
17. "000711" "2008-06-30" "A" "25185210.31"
    
18. "000711" "2008-09-30" "A" "39386456.05"
    
19. "000711" "2008-12-31" "A" "52613373.04"
    
20. end

复制代码

非常感谢各位大神帮忙！！！！

扫码加我 拉你入群

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

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

分享0 收藏3 回帖

请问有谁可以帮帮忙吗？？

已经做出来啦~！

g year=substr(accper,1,4)
bys stkcd year: egen num=total(sinc)

lancelot22 发表于 2018-4-9 23:47
已经做出来啦~！

怎么做的，同求，遇到相同问题

浅浅呐 发表于 2018-12-16 11:14
怎么做的，同求，遇到相同问题

稍微修改楼上之程序即可：

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 stkcd str10 accper str1 type str12 sinc
   
4. "000592" "2007-03-31" "A" "74170.55"   
   
5. "000592" "2007-06-30" "A" "94760"      
   
6. "000592" "2007-09-30" "A" "125850"      
   
7. "000592" "2007-12-31" "A" "189250"      
   
8. "000592" "2008-03-31" "A" "50665460.73"
   
9. "000592" "2008-06-30" "A" "129282793.45"
   
10. "000592" "2008-09-30" "A" "212003161.3"
    
11. "000592" "2008-12-31" "A" "283526011.92"
    
12. "000711" "2007-03-31" "A" "1229012.8"   
    
13. "000711" "2007-06-30" "A" "174198106.2"
    
14. "000711" "2007-09-30" "A" "184116796.19"
    
15. "000711" "2007-12-31" "A" "194816688.5"
    
16. "000711" "2008-03-31" "A" "12303561.67"
    
17. "000711" "2008-06-30" "A" "25185210.31"
    
18. "000711" "2008-09-30" "A" "39386456.05"
    
19. "000711" "2008-12-31" "A" "52613373.04"
    
20. end
    
21. 
    
22. gen year = substr(accper,1,4)
    
23. destring year sinc, replace
    
24. bys stkcd year: egen num = total(sinc)

复制代码

lancelot22 发表于 2018-4-9 23:47
已经做出来啦~！

我也遇到这个问题，可以指教下怎么做的吗