计算单个季度的利润

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input long Stkcd str13 Accper double B002000000 byte month int year double quarter
   
4. 1 "2015-03-31"     5.629e+09  3 2015 1
   
5. 1 "2015-06-30"    1.1585e+10  6 2015 2
   
6. 1 "2015-09-30"     1.774e+10  9 2015 3
   
7. 1 "2015-12-31"    2.1865e+10 12 2015 4
   
8. 1 "2016-03-31"     6.086e+09  3 2016 1
   
9. 1 "2016-06-30"    1.2292e+10  6 2016 2
   
10. 1 "2016-09-30"    1.8719e+10  9 2016 3
    
11. 1 "2016-12-31"    2.2599e+10 12 2016 4
    
12. 1 "2017-03-31"     6.214e+09  3 2017 1
    
13. 1 "2017-06-30"    1.2554e+10  6 2017 2
    
14. 1 "2017-09-30"    1.9153e+10  9 2017 3
    
15. 1 "2017-12-31"    2.3189e+10 12 2017 4
    
16. 1 "2018-03-31"     6.595e+09  3 2018 1
    
17. 1 "2018-06-30"    1.3372e+10  6 2018 2
    
18. 1 "2018-09-30"    2.0456e+10  9 2018 3
    
19. 1 "2018-12-31"    2.4818e+10 12 2018 4
    
20. 2 "2004-03-31"  110005143.63  3 2004 1
    
21. 2 "2004-06-30"  333571003.74  6 2004 2
    
22. 2 "2004-09-30"  398601575.66  9 2004 3
    
23. 2 "2004-12-31"  912653719.73 12 2004 4
    
24. 2 "2005-03-31"  248901014.43  3 2005 1
    
25. 2 "2005-06-30"  813192444.76  6 2005 2
    
26. 2 "2005-09-30"  889093798.22  9 2005 3
    
27. 2 "2005-12-31" 1433425711.84 12 2005 4
    
28. 2 "2006-03-31"  389056646.94  3 2006 1
    
29. 2 "2006-06-30" 1226963029.67  6 2006 2
    
30. 2 "2006-09-30" 1363735879.79  9 2006 3
    
31. 2 "2006-12-31" 2308440478.62 12 2006 4
    
32. 2 "2007-03-31"  616108912.17  3 2007 1
    
33. 2 "2007-06-30" 1800864980.15  6 2007 2
    
34. 2 "2007-09-30" 2090598444.43  9 2007 3
    
35. 2 "2007-12-31" 5317500817.82 12 2007 4
    
36. 2 "2008-03-31"  741729795.71  3 2008 1
    
37. 2 "2008-06-30" 2306670070.14  6 2008 2
    
38. 2 "2008-09-30" 2634320361.16  9 2008 3
    
39. 2 "2008-12-31" 4639869152.73 12 2008 4
    
40. 2 "2009-03-31"  888542552.19  3 2009 1
    
41. 2 "2009-06-30" 3100227254.79  6 2009 2
    
42. 2 "2009-09-30" 3669981960.35  9 2009 3
    
43. 2 "2009-12-31" 6430007538.69 12 2009 4
    
44. end

复制代码

扫码加我 拉你入群

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

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

分享0 收藏1 回帖

关键词：generated generate install Quarter example

试试

1. gen ymd = date(Accper, "YMD")
   
2. format ymd %td
   
3. gen yq = qofd(ymd)
   
4. format yq %tq
   
5. 
   
6. xtset Stkcd yq
   
7. gen wanted = B002000000-L.B002000000

复制代码

黃河泉 发表于 2019-10-27 19:00
试试

黄老师，这个得分公司分年度吧，我不会分组计算，您这样好像少了分年度

______沉、默 发表于 2019-10-27 19:11
黄老师，这个得分公司分年度吧，我不会分组计算，您这样好像少了分年度

我猜也是 (你没说明)，请试试

1. sort Stkcd year quarter
   
2. by Stkcd year: gen wanted = B002000000-B002000000[_n-1]

复制代码

黃河泉 发表于 2019-10-28 06:29
我猜也是 (你没说明)，请试试

解决了，谢谢黄老师