给根据其他变量给某一变量编号

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

示例如下，如何根据company_id和event_date编号，从1到60，并且删除小于60的company_id记录？谢谢


----------------------- copy starting from the next line -----------------------

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 company_id int(event_date Enddt) float car
   
4. "000002" 18737 18717      -.0221
   
5. "000002" 18737 18717      -.0086
   
6. "000002" 18737 18717       .0086
   
7. "000002" 18737 18717       .0264
   
8. "000002" 18737 18717       .0215
   
9. "000002" 18737 18717         .04
   
10. "000002" 18737 18717       .0457
    
11. "000002" 18737 18717       .0366
    
12. "000002" 18737 18717       .0393
    
13. "000002" 18737 18717       .0386
    
14. "000002" 18737 18717       .0287
    
15. "000002" 18737 18717        .023
    
16. "000002" 18737 18717       .0177
    
17. "000002" 18737 18717       .0124
    
18. "000002" 18737 18717       .0214
    
19. "000002" 18737 18717        .024
    
20. "000002" 18737 18717       .0335
    
21. "000002" 18737 18717       .0388
    
22. "000002" 18737 18717  .035099998
    
23. "000002" 18737 18717       .0219
    
24. "000002" 18737 18717       .0235
    
25. "000002" 18737 18717       .0353
    
26. "000002" 18737 18717       .0339
    
27. "000002" 18737 18717       .0293
    
28. "000002" 18737 18717       .0433
    
29. "000002" 18737 18717       .0765
    
30. "000002" 18737 18717       .0742
    
31. "000002" 18737 18717       .0593
    
32. "000002" 18737 18717       .0468
    
33. "000002" 18737 18717       .0488
    
34. "000002" 18737 18717       .0407
    
35. "000002" 18737 18717       .0356
    
36. "000002" 18737 18717       .0691
    
37. "000002" 18737 18717       .0656
    
38. "000002" 18737 18717       .0777
    
39. "000002" 18737 18717       .0673
    
40. "000002" 18737 18717       .0855
    
41. "000002" 18737 18717       .0827
    
42. "000002" 18737 18717       .0923
    
43. "000002" 18737 18717       .1111
    
44. "000002" 18737 18717       .1386
    
45. "000002" 18737 18717       .1345
    
46. "000002" 18737 18717   .12900001
    
47. "000002" 18737 18717       .1134
    
48. "000002" 18737 18717       .1029
    
49. "000002" 18737 18717        .081
    
50. "000002" 18737 18717       .0804
    
51. "000002" 18737 18717       .0879
    
52. "000002" 18737 18717       .0937
    
53. "000002" 18737 18717       .1148
    
54. "000002" 18737 18717        .094
    
55. "000002" 18737 18717       .1026
    
56. "000002" 18737 18717       .0961
    
57. "000002" 18737 18717       .0889
    
58. "000002" 18737 18717       .0951
    
59. "000002" 18737 18717       .0796
    
60. "000002" 18737 18717       .0659
    
61. "000002" 18737 18717       .0599
    
62. "000002" 18737 18717       .0488
    
63. "000002" 18737 18717       .0237
    
64. "000002" 18848 18808       .0335
    
65. "000002" 18848 18808      -.0054
    
66. "000002" 18848 18808      -.0298
    
67. "000002" 18848 18808       -.036
    
68. "000002" 18848 18808      -.0452
    
69. "000002" 18848 18808      -.0592
    
70. "000002" 18848 18808      -.0503
    
71. "000002" 18848 18808      -.0421
    
72. "000002" 18848 18808       -.041
    
73. "000002" 18848 18808      -.0421
    
74. "000002" 18848 18808        -.05
    
75. "000002" 18848 18808      -.0354
    
76. "000002" 18848 18808      -.0457
    
77. "000002" 18848 18808      -.0616
    
78. "000002" 18848 18808      -.0551
    
79. "000002" 18848 18808      -.0492
    
80. "000002" 18848 18808      -.0444
    
81. "000002" 18848 18808       -.038
    
82. "000002" 18848 18808      -.0214
    
83. "000002" 18848 18808      -.0138
    
84. "000002" 18848 18808      -.0235
    
85. "000002" 18848 18808       -.016
    
86. "000002" 18848 18808 -.012300001
    
87. "000002" 18848 18808  .002399999
    
88. "000002" 18848 18808 -.006600001
    
89. "000002" 18848 18808 -.007700001
    
90. "000002" 18848 18808      -.0117
    
91. "000002" 18848 18808      -.0252
    
92. "000002" 18848 18808 -.037100002
    
93. "000002" 18848 18808      -.0472
    
94. "000002" 18848 18808      -.0701
    
95. "000002" 18848 18808      -.0686
    
96. "000002" 18848 18808      -.0857
    
97. "000002" 18848 18808      -.0868
    
98. "000002" 18848 18808      -.0839
    
99. "000002" 18848 18808      -.0436
    
100. "000002" 18848 18808 -.033400003
     
101. "000002" 18848 18808      -.0598
     
102. "000002" 18848 18808      -.0483
     
103. "000002" 18848 18808      -.0417
     
104. end
     
105. format %td event_date
     
106. format %tddd-Mon-YY Enddt

复制代码

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

Listed 100 out of 158010 observations
Use the count() option to list more

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：observations observation generated including observat

无法理解你的问题，请根据你的资料说明。

请使用代码：

1. egen id = group(company_id event_date)
   
2. drop if id <60

复制代码

根据你的要求写完代码后，觉得哪里奇怪？你这是要干啥，编号1-60，又删掉小于60的，那只剩最后一个了？请先搞明白你究竟要干啥，然后对照上述命令去适当修改一下。