stata对时间数据的处理，只想保留每一年份12月31日的数据

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 stkcd str10 accper float roa
   
4. "000001" "2009-09-30"  .006563
   
5. "000001" "2009-12-31"  .008558
   
6. "000001" "2010-03-31"  .002546
   
7. "000001" "2010-06-30"  .004858
   
8. "000001" "2010-09-30"  .007013
   
9. "000001" "2010-12-31"  .008641
   
10. "000001" "2011-03-31"  .002975
    
11. "000001" "2011-06-30"  .005553
    
12. "000001" "2011-09-30"  .006416
    
13. "000001" "2011-09-30"  .007651
    
14. "000001" "2011-12-31"  .008258
    
15. "000001" "2011-12-31"  .009295
    
16. "000001" "2012-03-31"  .002552
    
17. "000001" "2012-03-31"  .002555
    
18. "000001" "2012-06-30"  .005443
    
19. "000001" "2012-06-30"  .004609
    
20. "000001" "2012-09-30"  .007002
    
21. "000001" "2012-09-30"  .007844
    
22. "000001" "2012-12-31"   .00841
    
23. "000001" "2012-12-31"  .009184
    
24. "000001" "2013-03-31"  .001982
    
25. "000001" "2013-06-30"  .004122
    
26. "000001" "2013-09-30"  .006303
    
27. "000001" "2013-12-31"  .008051
    
28. "000001" "2014-03-31"   .00241
    
29. "000001" "2014-06-30"  .004714
    
30. "000001" "2014-09-30"  .007319
    
31. "000001" "2014-12-31"  .009057
    
32. "000001" "2015-03-31"  .002442
    
33. "000001" "2015-06-30"  .004507
    
34. "000001" "2015-09-30"  .006826
    
35. "000001" "2015-12-31"  .008721
    
36. "000001" "2016-03-31"   .00227
    
37. "000001" "2016-06-30"  .004388
    
38. "000001" "2016-09-30"  .006706
    
39. "000001" "2016-12-31"  .007652
    
40. "000001" "2017-03-31"  .002067
    
41. "000001" "2017-06-30"   .00406
    
42. "000002" "2009-09-30"  .043734
    
43. "000002" "2009-09-30"  .028339
    
44. "000002" "2009-12-31"  .046736
    
45. "000002" "2009-12-31"  .046727
    
46. "000002" "2010-03-31"  .007924
    
47. "000002" "2010-03-31" 6.00e-06
    
48. "000002" "2010-06-30"  .019692
    
49. "000002" "2010-06-30"  .041257
    
50. "000002" "2010-09-30"  .020356
    
51. "000002" "2010-09-30"  .038041
    
52. "000002" "2010-12-31"    .0365
    
53. "000002" "2010-12-31"  .040993
    
54. "000002" "2011-03-31"  .005056
    
55. "000002" "2011-03-31"  .001144
    
56. "000002" "2011-06-30"   .04811
    
57. "000002" "2011-06-30"  .012464
    
58. "000002" "2011-09-30"  .048433
    
59. "000002" "2011-09-30"    .0145
    
60. "000002" "2011-12-31"   .03916
    
61. "000002" "2011-12-31"  .047674
    
62. "000002" "2012-03-31" -.000596
    
63. "000002" "2012-03-31"   .00493
    
64. "000002" "2012-06-30"  .013727
    
65. "000002" "2012-06-30"  .046446
    
66. "000002" "2012-09-30"  .017673
    
67. "000002" "2012-09-30"  .044301
    
68. "000002" "2012-12-31"  .041348
    
69. "000002" "2012-12-31"  .044363
    
70. "000002" "2013-03-31" -.001215
    
71. "000002" "2013-03-31"  .004282
    
72. "000002" "2013-06-30"  .012345
    
73. "000002" "2013-06-30"  .049635
    
74. "000002" "2013-09-30"  .016215
    
75. "000002" "2013-09-30"  .044213
    
76. "000002" "2013-12-31"  .038183
    
77. "000002" "2013-12-31"  .047635
    
78. "000002" "2014-03-31"  .003309
    
79. "000002" "2014-03-31" -.000683
    
80. "000002" "2014-06-30"  .010946
    
81. "000002" "2014-06-30"  .068065
    
82. "000002" "2014-09-30"  .014626
    
83. "000002" "2014-09-30"   .06608
    
84. "000002" "2014-12-31"  .037937
    
85. "000002" "2014-12-31"  .068065
    
86. "000002" "2015-03-31"  .001726
    
87. "000002" "2015-03-31"  .002377
    
88. "000002" "2015-06-30"  .012645
    
89. "000002" "2015-06-30"  .040639
    
90. "000002" "2015-09-30"  .016711
    
91. "000002" "2015-09-30"  .041118
    
92. "000002" "2015-12-31"   .04245
    
93. "000002" "2015-12-31"  .051133
    
94. "000002" "2016-03-31"  .001897
    
95. "000002" "2016-03-31"  .001049
    
96. "000002" "2016-06-30"   .00996
    
97. "000002" "2016-06-30"  .067025
    
98. "000002" "2016-09-30"  .014936
    
99. "000002" "2016-09-30"  .072631
    
100. "000002" "2016-12-31"  .034129
     
101. "000002" "2016-12-31"  .057943
     
102. "000002" "2017-03-31"  .001251
     
103. "000002" "2017-03-31" -.001138
     
104. end

复制代码

想要只保留每一年份12-31的数据，求助怎么写代码

扫码加我 拉你入群

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

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

分享0 收藏1 回帖

关键词：Stata tata generated generate install

1. keep  if substr(accper,6,10)=="12-31"

复制代码

蓝色 发表于 2019-8-13 20:05

谢谢蓝老师！

请问解决了吗 我复制了命令但是一直显示command keep if is unrecognized，请问是怎么回事?

砰砰圆 发表于 2021-1-25 20:49
请问解决了吗 我复制了命令但是一直显示command keep if is unrecognized，请问是怎么回事?

同遇到了这个问题，请问您现在解决了吗？

不要复制代码，手动输入一遍就能成功了。