如何写if命令不在开始剔除样本而是在计算中剔除样本

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

我希望能够计算剔除自身的分组（按hs6分组）的均值，这个需求能够用rangestat命令解决，但是我还希望在计算均值时只保留share>=0.2的样本，请问怎么写if命令能够让我不在一开始就把share<0.2的样本从总样本中扣除，而是在计算均值时不去考虑这部分企业。部分样本举例如下（这三条样本是一个分组内的）：比如说这个分组内id_new为23804的企业自身share是小于0.2的（但我不想现在把它剔除掉），而是在算这个企业的剔除自身的分组均值时，同组内只有id_new为212458的企业share是大于0.2的，所以计算的时候只把id_new为212458的企业的qua用于计算均值，也就是说id_new为23804的企业计算得出的剔除自身的分组均值应该为0.739726，id_new为212458的企业计算得出的剔除自身的分组均值是缺失值（因为组内没有其他share大于0.2的企业了），id_new为764066 的企业计算得出的剔除自身的分组均值是0.739726。感谢赐教
year        hs6        id_new        qua        weight
2006        709592        23804        0.750268        0.121525
2006        709592        212458        0.739726        0.634955
2006        709592        764066        0.776472        0.095881

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int year long(hs6 id_new) float(qua weight)
   
4. 2001 210690 639897 .5971524 .06278268
   
5. 2001 210690 429748 .7219472 .09100122
   
6. 2001 210690 640383 .6806234  .3911454
   
7. 2001 504001 125266 .6565912  .0789826
   
8. 2001 504001 362200 .5553624 .09514473
   
9. 2001 504001  97877 .7238123 .10465258
   
10. 2001 712905 606955 .6484273 .00296649
    
11. 2001 712905 583240 .6936182 .05591295
    
12. 2001 712905 475238 .6706958 .09341856
    
13. 2001 712905 348685  .346536 .00740762
    
14. 2001 712905 606955 .7018317  .1323507
    
15. 2001 712905 583240  .678131  .4991793
    
16. 2001 712909 583240 .6936182 .00468697
    
17. 2001 712909 348685 .6929718 .02645013
    
18. 2001 712909 475238 .6706958  .0749915
    
19. 2001 712909 606955 .6484273 .09076316
    
20. 2001 910100 583240 .6850597 .09919316
    
21. 2001 910100 186119 .6505734 .10536308
    
22. 2001 910100 688331 .7094862 .20939724
    
23. 2001 303799 606314 .6657142 .05503341
    
24. 2001 303799 647081 .7346175 .06492222
    
25. 2001 303799 606260  .642151 .19698806
    
26. 2001 303799 606353 .6993695 .54510015
    
27. 2001 160419 647141 .7364116 .01773071
    
28. 2001 160419 606815 .6905003  .4362861
    
29. 2001 160419 647127 .7745591  .5249882
    
30. 2001 304200 647127 .7745591  .0854356
    
31. 2001 304200 606815 .6905003 .24785385
    
32. 2001 304200 647141 .7364116  .5736198
    
33. 2001 160232 330255 .8593022 .00011993
    
34. 2001 160232 291395 .7751698 .03171293
    
35. 2001 160232 284039 .7572191 .05988389
    
36. 2001 160232 607280 .6928668 .08411492
    
37. 2001 160232 646957 .7301203 .10288646
    
38. 2001 160232 691113 .7415168   .112046
    
39. 2001 200490 330255 .8593022   .000055
    
40. 2001 200490 646990 .7023686 .23593466
    
41. 2001 200490 284039 .7572191  .3727933
    
42. 2001 207141 607280 .6213617 .00956004
    
43. 2001 207141 330255 .6526461  .0097858
    
44. 2001 207141 308487 .6306639 .01166229
    
45. 2001 207141 646970 .8017347  3.01e-07
    
46. 2001 207141 607280 .6928668  9.03e-07
    
47. 2001 207141 691113 .7415168 .04167438
    
48. 2001 207141 330255 .8593022 .08302157
    
49. 2001 207141 308487 .6929866 .11949571
    
50. 2001 207141 291395 .7751698  .4454074
    
51. 2001 706900 712140 .7581716 .03513386
    
52. 2001 706900 646980 .7279024  .4015673
    
53. 2001 706900 168233 .7360066  .5632988
    
54. 2001 710809 330255 .8593022 .00001058
    
55. 2001 710809 168233 .7360066 .01752932
    
56. 2001 710809 284039 .7572191  .1972516
    
57. 2001 710809 236509 .7393443  .3935511
    
58. 2001 710900 168233 .7360066 .00001265
    
59. 2001 710900 646980 .7279024 .00201108
    
60. 2001 710900 236509 .7393443  .9979762
    
61. 2001 714909 646980 .7279024 .00251535
    
62. 2001 714909 712142 .8485562 .10682085
    
63. 2001 714909 168233 .7360066  .8906638
    
64. 2001 910100 442016 .6552313 .00117096
    
65. 2001 910100 168233 .7360066 .02023788
    
66. 2001 910100 329319 .7357813 .25442728
    
67. 2001 910100 712140 .7581716  .6233192
    
68. 2001 160590  37224 .7503176 .14589918
    
69. 2001 160590 712098 .7222415 .15250984
    
70. 2001 160590 536531 .7213944 .22042602
    
71. 2001 160590 179919 .7918543  .3758631
    
72. 2001 160590 646758 .6753042 .00399213
    
73. 2001 160590  37224 .6413493 .02753038
    
74. 2001 160590 179919 .7107481 .07377931
    
75. 2001 190230 646758 .6753042 .01150404
    
76. 2001 190230 646796 .6788233 .01977756
    
77. 2001 190230 152240 .7065789 .02917174
    
78. 2001 190230 646809 .7181308 .03318172
    
79. 2001 190230 646809 .6343896 .03650928
    
80. 2001 190230 646796 .7269751 .13556924
    
81. 2001 190230 152240 .7702454  .2734518
    
82. 2001 200490 646840  .795336 .00985387
    
83. 2001 200490 646805 .8315113 .04485505
    
84. 2001 200490 646754 .8246877 .11877882
    
85. 2001 200490 646865 .8537781  .8265123
    
86. 2001 200970 646850 .6116398 .00005251
    
87. 2001 200970 607350 .6462064 .00967138
    
88. 2001 200970 646864 .8477886   .372074
    
89. 2001 303799 712076 .7187326 .00704454
    
90. 2001 303799  37224 .6854123 .04137393
    
91. 2001 303799 179919 .6413665 .09086592
    
92. 2001 303799 712098  .749734  .8607156
    
93. 2001 304200 638987 .6900073 .05394824
    
94. 2001 304200 712103 .7150853   .059745
    
95. 2001 304200 712098  .720076 .14335263
    
96. 2001 304200 712103 .6672368  .0562746
    
97. 2001 304200 712098 .6672235 .06054925
    
98. 2001 304200  37224 .6651472 .07256994
    
99. 2001 304200 712103 .6726308 .03442604
    
100. 2001 304200  37224 .6413493 .04330628
     
101. 2001 304200 638987 .6563069 .05039633
     
102. 2001 304200 712098 .6822562 .15301552
     
103. 2001 307490 646754 .8246877  6.93e-06
     
104. end

复制代码

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：如何写 share estat range ARE