1963 4

[面板数据求助] 【附dataex】求问stata如何将各公司各自然日下各变量数据加总为年度 [推广有奖]

  • 0关注
  • 0粉丝

大专生

23%

还不是VIP/贵宾

-

0%
威望
0 级
论坛币
967 个
通用积分
1.5850
学术水平
0 点
热心指数
0 点
信用等级
0 点
经验
94 点
帖子
10
精华
0
在线时间
83 小时
注册时间
2019-3-14
最后登录
2020-5-22
楼主
果然是西红柿 发表于 2019-4-9 23:21:43 |AI写论文

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币
求问stata如何将数据根据同一年份加总，生成公司-年度下各变量的加总值
  1. * Example generated by -dataex-. To install: ssc install dataex
  2. clear
  3. input str12(code Coname Date) str36(Newsnum_Title Newsnum_Cont) str27(Posnews_All Neunews_All Negnews_All Posnews_Ori Neunews_Ori Negnews_Ori)
  4. "000002" "万科A" "2007-01-02" "0" "1"  "1"  "0" "0"  "1" "0" "0"
  5. "000002" "万科A" "2007-01-03" "0" "1"  "0"  "0" "1"  "0" "0" "1"
  6. "000002" "万科A" "2007-01-04" "0" "1"  "1"  "0" "0"  "1" "0" "0"
  7. "000002" "万科A" "2007-01-05" "0" "1"  "1"  "0" "0"  "1" "0" "0"
  8. "000002" "万科A" "2007-01-08" "0" "10" "5"  "4" "1"  "2" "2" "0"
  9. "000002" "万科A" "2007-01-09" "0" "1"  "0"  "1" "0"  "0" "0" "0"
  10. "000002" "万科A" "2007-01-10" "0" "1"  "0"  "1" "0"  "0" "0" "0"
  11. "000002" "万科A" "2007-01-11" "1" "4"  "1"  "2" "1"  "1" "1" "0"
  12. "000002" "万科A" "2007-01-12" "1" "6"  "5"  "1" "1"  "3" "0" "1"
  13. "000002" "万科A" "2007-01-14" "0" "1"  "1"  "0" "0"  "0" "0" "0"
  14. "000002" "万科A" "2007-01-15" "0" "3"  "2"  "0" "1"  "1" "0" "1"
  15. "000002" "万科A" "2007-01-16" "0" "3"  "1"  "1" "1"  "1" "1" "0"
  16. "000002" "万科A" "2007-01-17" "1" "16" "9"  "3" "4"  "7" "1" "1"
  17. "000002" "万科A" "2007-01-18" "0" "33" "8"  "3" "22" "1" "2" "4"
  18. "000002" "万科A" "2007-01-19" "0" "16" "6"  "2" "8"  "1" "1" "1"
  19. "000002" "万科A" "2007-01-20" "0" "5"  "3"  "1" "1"  "1" "0" "0"
  20. "000002" "万科A" "2007-01-21" "0" "2"  "0"  "1" "1"  "0" "1" "0"
  21. "000002" "万科A" "2007-01-22" "0" "5"  "3"  "0" "2"  "0" "0" "0"
  22. "000002" "万科A" "2007-01-23" "0" "1"  "1"  "0" "0"  "1" "0" "0"
  23. "000002" "万科A" "2007-01-24" "0" "4"  "3"  "0" "1"  "1" "0" "1"
  24. "000002" "万科A" "2007-01-25" "0" "6"  "0"  "3" "3"  "0" "3" "2"
  25. "000002" "万科A" "2007-01-26" "0" "5"  "1"  "2" "2"  "0" "1" "1"
  26. "000002" "万科A" "2007-01-28" "0" "2"  "1"  "0" "1"  "0" "0" "1"
  27. "000002" "万科A" "2007-01-29" "0" "7"  "1"  "0" "6"  "0" "0" "0"
  28. "000002" "万科A" "2007-01-30" "0" "7"  "3"  "1" "3"  "3" "0" "1"
  29. "000002" "万科A" "2007-01-31" "0" "7"  "1"  "2" "4"  "1" "1" "2"
  30. "000002" "万科A" "2007-02-01" "0" "1"  "0"  "1" "0"  "0" "1" "0"
  31. "000002" "万科A" "2007-02-02" "0" "5"  "1"  "1" "3"  "0" "0" "3"
  32. "000002" "万科A" "2007-02-05" "0" "6"  "0"  "1" "5"  "0" "0" "1"
  33. "000002" "万科A" "2007-02-06" "0" "3"  "2"  "0" "1"  "2" "0" "0"
  34. "000002" "万科A" "2007-02-07" "0" "4"  "3"  "0" "1"  "1" "0" "1"
  35. "000002" "万科A" "2007-02-08" "1" "6"  "2"  "1" "3"  "1" "0" "3"
  36. "000002" "万科A" "2007-02-09" "0" "11" "3"  "2" "6"  "1" "1" "4"
  37. "000002" "万科A" "2007-02-12" "0" "9"  "7"  "2" "0"  "2" "1" "0"
  38. "000002" "万科A" "2007-02-13" "0" "1"  "1"  "0" "0"  "1" "0" "0"
  39. "000002" "万科A" "2007-02-14" "0" "3"  "1"  "2" "0"  "1" "2" "0"
  40. "000002" "万科A" "2007-02-15" "0" "3"  "0"  "3" "0"  "0" "1" "0"
  41. "000002" "万科A" "2007-02-17" "0" "1"  "0"  "0" "1"  "0" "0" "1"
  42. "000002" "万科A" "2007-02-21" "0" "2"  "0"  "2" "0"  "0" "1" "0"
  43. "000002" "万科A" "2007-02-25" "0" "1"  "1"  "0" "0"  "1" "0" "0"
  44. "000002" "万科A" "2007-02-27" "0" "1"  "0"  "0" "1"  "0" "0" "1"
  45. "000002" "万科A" "2007-02-28" "0" "3"  "3"  "0" "0"  "1" "0" "0"
  46. "000002" "万科A" "2007-03-01" "0" "1"  "1"  "0" "0"  "0" "0" "0"
  47. "000002" "万科A" "2007-03-02" "0" "3"  "1"  "0" "2"  "1" "0" "2"
  48. "000002" "万科A" "2007-03-03" "0" "1"  "0"  "0" "1"  "0" "0" "1"
  49. "000002" "万科A" "2007-03-05" "0" "2"  "1"  "0" "1"  "1" "0" "1"
  50. "000002" "万科A" "2007-03-06" "0" "5"  "4"  "0" "1"  "2" "0" "1"
  51. "000002" "万科A" "2007-03-07" "0" "6"  "3"  "2" "1"  "2" "2" "1"
  52. "000002" "万科A" "2007-03-08" "0" "1"  "1"  "0" "0"  "0" "0" "0"
  53. "000002" "万科A" "2007-03-09" "0" "3"  "2"  "0" "1"  "0" "0" "0"
  54. "000002" "万科A" "2007-03-10" "0" "3"  "0"  "2" "1"  "0" "1" "0"
  55. "000002" "万科A" "2007-03-11" "0" "1"  "0"  "0" "1"  "0" "0" "1"
  56. "000002" "万科A" "2007-03-12" "0" "2"  "1"  "0" "1"  "1" "0" "1"
  57. "000002" "万科A" "2007-03-14" "0" "3"  "1"  "1" "1"  "1" "0" "0"
  58. "000002" "万科A" "2007-03-15" "1" "5"  "3"  "2" "1"  "1" "2" "0"
  59. "000002" "万科A" "2007-03-16" "0" "5"  "1"  "0" "4"  "1" "0" "2"
  60. "000002" "万科A" "2007-03-17" "0" "1"  "0"  "0" "1"  "0" "0" "0"
  61. "000002" "万科A" "2007-03-19" "0" "3"  "2"  "0" "1"  "2" "0" "1"
  62. "000002" "万科A" "2007-03-20" "1" "9"  "3"  "4" "2"  "2" "1" "1"
  63. "000002" "万科A" "2007-03-21" "0" "15" "6"  "7" "2"  "1" "6" "2"
  64. "000002" "万科A" "2007-03-22" "3" "3"  "2"  "2" "2"  "0" "1" "1"
  65. "000002" "万科A" "2007-03-23" "0" "6"  "2"  "2" "2"  "1" "0" "2"
  66. "000002" "万科A" "2007-03-26" "0" "3"  "2"  "1" "0"  "1" "1" "0"
  67. "000002" "万科A" "2007-03-27" "0" "3"  "0"  "1" "2"  "0" "0" "1"
  68. "000002" "万科A" "2007-03-28" "0" "3"  "2"  "1" "0"  "2" "1" "0"
  69. "000002" "万科A" "2007-03-29" "0" "8"  "6"  "2" "0"  "3" "2" "0"
  70. "000002" "万科A" "2007-03-30" "0" "5"  "2"  "2" "1"  "2" "2" "0"
  71. "000002" "万科A" "2007-03-31" "0" "1"  "1"  "0" "0"  "0" "0" "0"
  72. "000002" "万科A" "2007-04-02" "0" "2"  "0"  "0" "2"  "0" "0" "1"
  73. "000002" "万科A" "2007-04-03" "2" "5"  "5"  "1" "0"  "2" "1" "0"
  74. "000002" "万科A" "2007-04-04" "2" "4"  "2"  "3" "0"  "0" "2" "0"
  75. "000002" "万科A" "2007-04-05" "0" "4"  "1"  "1" "2"  "0" "1" "1"
  76. "000002" "万科A" "2007-04-06" "2" "4"  "1"  "3" "0"  "1" "1" "0"
  77. "000002" "万科A" "2007-04-07" "1" "0"  "1"  "0" "0"  "1" "0" "0"
  78. "000002" "万科A" "2007-04-09" "0" "2"  "1"  "0" "1"  "0" "0" "1"
  79. "000002" "万科A" "2007-04-10" "0" "3"  "2"  "0" "1"  "2" "0" "1"
  80. "000002" "万科A" "2007-04-11" "0" "3"  "1"  "0" "2"  "0" "0" "2"
  81. "000002" "万科A" "2007-04-12" "0" "2"  "2"  "0" "0"  "2" "0" "0"
  82. "000002" "万科A" "2007-04-13" "0" "1"  "0"  "0" "1"  "0" "0" "1"
  83. "000002" "万科A" "2007-04-14" "0" "3"  "2"  "1" "0"  "2" "1" "0"
  84. "000002" "万科A" "2007-04-16" "0" "4"  "3"  "1" "0"  "3" "0" "0"
  85. "000002" "万科A" "2007-04-17" "0" "5"  "3"  "2" "0"  "2" "2" "0"
  86. "000002" "万科A" "2007-04-18" "0" "1"  "0"  "0" "1"  "0" "0" "1"
  87. "000002" "万科A" "2007-04-20" "0" "3"  "2"  "0" "1"  "0" "0" "0"
  88. "000002" "万科A" "2007-04-21" "0" "2"  "0"  "1" "1"  "0" "1" "1"
  89. "000002" "万科A" "2007-04-22" "0" "1"  "0"  "0" "1"  "0" "0" "1"
  90. "000002" "万科A" "2007-04-23" "0" "3"  "0"  "2" "1"  "0" "2" "1"
  91. "000002" "万科A" "2007-04-24" "0" "5"  "0"  "2" "3"  "0" "2" "1"
  92. "000002" "万科A" "2007-04-25" "0" "2"  "0"  "1" "1"  "0" "1" "1"
  93. "000002" "万科A" "2007-04-26" "0" "1"  "0"  "0" "1"  "0" "0" "1"
  94. "000002" "万科A" "2007-04-27" "0" "8"  "3"  "2" "3"  "3" "2" "1"
  95. "000002" "万科A" "2007-04-28" "0" "2"  "1"  "0" "1"  "1" "0" "0"
  96. "000002" "万科A" "2007-04-29" "0" "2"  "1"  "0" "1"  "1" "0" "0"
  97. "000002" "万科A" "2007-04-30" "1" "4"  "4"  "1" "0"  "3" "1" "0"
  98. "000002" "万科A" "2007-05-02" "0" "1"  "0"  "0" "1"  "0" "0" "1"
  99. "000002" "万科A" "2007-05-06" "0" "1"  "0"  "1" "0"  "0" "1" "0"
  100. "000002" "万科A" "2007-05-08" "0" "9"  "6"  "2" "1"  "5" "1" "0"
  101. "000002" "万科A" "2007-05-09" "0" "17" "11" "5" "1"  "6" "3" "1"
  102. "000002" "万科A" "2007-05-10" "0" "6"  "1"  "2" "3"  "1" "1" "2"
  103. "000002" "万科A" "2007-05-11" "0" "6"  "2"  "3" "1"  "2" "1" "1"
  104. end
复制代码



二维码

扫码加我 拉你入群

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

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

分享0
关键词：000002 万科A 各变量

相关帖子

回帖推荐

黃河泉 发表于4楼  查看完整内容

试试
沙发
东方皓天 发表于 2019-4-9 23:48:59 来自手机
果然是西红柿 发表于 2019-4-9 23:21
求问stata如何将数据根据同一年份加总，生成公司-年度下各变量的加总值
excle搞定不了？
藤椅
蓝色 发表于 2019-4-10 06:26:12 来自手机
先用函数产生年份变量
然后用egen产生需要的
板凳
黃河泉 在职认证  发表于 2019-4-10 06:52:18
试试
  1. destring, replace
  2. gen ymd = date(Date, "YMD")
  3. format ymd %td
  4. gen year = year(ymd)

  6. bys code year: egen Newsnum_Title_sum = sum(Newsnum_Title)
复制代码
已有 1 人评分学术水平 热心指数 信用等级 收起 理由
果然是西红柿 + 1 + 1 + 1 精彩帖子

总评分: 学术水平 + 1  热心指数 + 1  信用等级 + 1   查看全部评分

报纸
果然是西红柿 发表于 2019-4-10 16:41:15
黃河泉 发表于 2019-4-10 06:52
试试
谢谢老师！
返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注jltj
拉您入交流群

京ICP备16021002号-2 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问：王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2026-2-6 11:55