请教大神如下问题:
按照年分year和行业ingdustry进行分组(年度-行业样本中),分组后把每个变量有小到大分成5组,最小组赋值0分,次小组赋值1分,以此类推,最大组赋值4分。
这个在stata中,程序应该是什么?
我用cut函数,egen new-var =cut(var),group(5) 但是cut不能和by结合用。而且不知道怎么赋值。
我把部分数据贴在下面,感谢高手帮忙!
| code | year | industry | aa | bb | cc | dd | ee |
| 600359 | 2012 | A | 0.005116 | 0.1166 | 0.081959 | 0.251577 | 1497.123 |
| 600313 | 2012 | A | 0.026512 | 0.066102 | 0.521854 | 0.07035 | 233.6371 |
| 735 | 2012 | A | 0.394471 | 0.140508 | 0.022535 | 0.28065 | 91.19005 |
| 2041 | 2012 | A | 0.035767 | 0.256873 | 0.316203 | 0.209333 | 176.3061 |
| 600965 | 2012 | A | 0.06928 | 0.084312 | 0.027331 | 0.420479 | 134.7253 |
| 600506 | 2012 | A | 1.559341 | 0.37124 | 0.389557 | 0.195667 | 12.5698 |
| 600540 | 2012 | A | 0.034308 | 0.048333 | 0.344611 | 0.219365 | 1562.229 |
| 2086 | 2012 | A | 0.07925 | 0.068911 | 0.095064 | 0.470282 | 31.80393 |
| 600467 | 2012 | A | 0.092383 | 0.073376 | 0.099411 | 0.526313 | 53.45127 |
| 600311 | 2012 | B | 0.494901 | 0.291844 | 0.360693 | 0.509246 | 465.368 |
| 601918 | 2012 | B | 0.167412 | 0.066836 | 0.211431 | 0.41131 | 4227.044 |
| 780 | 2012 | B | 0.28054 | 0.118268 | 0.263812 | 0.265184 | 90.46376 |
| 600259 | 2012 | B | 0.265883 | 0.09451 | 0.350992 | 0.093119 | 65.29113 |
| 426 | 2012 | B | 1.799296 | 0.177403 | 0.220001 | 0.384989 | 49.55491 |
| 600497 | 2012 | B | 0.182009 | 0.107643 | 0.21494 | 0.304304 | 1627.5 |
| 2128 | 2012 | B | 0.100899 | 0.070551 | 0.221542 | 0.476681 | 116.3722 |
| 600188 | 2012 | B | 0.511626 | 0.148655 | 0.328198 | 0.24685 | 8817.531 |
| 600988 | 2012 | B | 0.255861 | 0.188156 | 2.546924 | 0.194488 | 46.49731 |
| 600489 | 2012 | B | 0.140637 | 0.045012 | 0.271956 | 0.270202 | 3979.477 |
| 600559 | 2013 | C1 | 0.09357 | 0.248549 | 0.254766 | 0.250276 | 96.2711 |
| 2015 | 2013 | C1 | 0.084336 | 0.03171 | 0.141371 | 0.291158 | 242.0539 |
| 600630 | 2013 | C1 | 0.016018 | 0.169716 | 0.04174 | 0.189722 | 668.0334 |
| 596 | 2013 | C1 | 0.072723 | 0.355924 | 0.298837 | 0.180019 | 782.4535 |
| 600298 | 2013 | C1 | 0.060552 | 0.166694 | 0.191412 | 0.520655 | 2281.751 |
| 850 | 2013 | C1 | 0.130343 | 0.052292 | 0.079259 | 0.333101 | 316.757 |
| 158 | 2013 | C1 | 0.045501 | 0.045776 | 0.146197 | 0.285591 | 3860.152 |
| 848 | 2013 | C1 | 0.1784 | 0.20435 | 0.128909 | 0.158206 | 205.407 |
| 2124 | 2013 | C1 | 0.063997 | 0.12192 | 0.165326 | 0.34919 | 243.7573 |
| 860 | 2013 | C1 | 0.08965 | 0.150334 | 0.120648 | 0.223795 | 472.9801 |
| 600063 | 2013 | C2 | 0.06668 | 0.095576 | 0.138873 | 0.463206 | 1079.269 |
| 600771 | 2013 | C2 | 0.135522 | 0.636681 | -0.02149 | 0.309229 | 592.3855 |
| 902 | 2013 | C2 | 0.018319 | 0.04827 | -0.01169 | 0.249712 | 570.8565 |
| 600535 | 2013 | C2 | 0.036346 | 0.197095 | 0.269784 | 0.22911 | 2305.85 |
| 600230 | 2013 | C2 | 0.05269 | 0.093098 | 0.135588 | 0.572018 | 601.069 |
| 600143 | 2013 | C2 | 0.061892 | 0.09018 | 0.159651 | 0.162035 | 1218.691 |
| 565 | 2013 | C2 | 0.105007 | 0.220317 | 0.078109 | 0.279606 | 185.0532 |
| 576 | 2013 | C2 | 0.263112 | 0.238994 | -0.05566 | 0.299406 | 952.5431 |
| 792 | 2013 | C2 | 0.06166 | 0.159616 | 0.15487 | 0.226878 | 6684.221 |
| 815 | 2013 | C2 | 0.175483 | 0.080587 | -0.08888 | 0.375558 | 682.6736 |
| 806 | 2013 | C3 | 0.25932 | 0.219736 | -0.13099 | 0.168659 | 109.4884 |
| 600839 | 2013 | C3 | 0.071452 | 0.140322 | 0.166068 | 0.167779 | 3276.898 |
| 546 | 2013 | C3 | 0.043699 | 0.127028 | 11.64884 | 0.030492 | 13.43505 |
| 2114 | 2013 | C3 | 0.161982 | 0.08052 | 0.019964 | 0.403751 | 51.34747 |
| 933 | 2013 | C3 | 0.13234 | 0.036662 | 0.224549 | 0.422037 | 4499.15 |
| 2025 | 2013 | C3 | 0.099126 | 0.25707 | 0.230784 | 0.202098 | 96.31408 |
| 2088 | 2013 | C3 | 0.127452 | 0.165585 | 0.051118 | 0.360999 | 91.49624 |
| 600698 | 2013 | C3 | 0.090956 | 0.18375 | -0.20262 | 0.253171 | 1631.074 |
| 600353 | 2013 | C3 | 0.105616 | 0.173985 | 0.073747 | 0.172359 | 48.97385 |
| 600495 | 2013 | C3 | 0.016289 | 0.082061 | 0.130957 | 0.194818 | 684.1755 |