面板数据如下表所示,请问各位大神如何将asset值大小排序前10%的样本定义为SIZE=1,将剩下的90%定义为SIZE=0呢?根据大小排序定义虚拟变量SIZE的语句怎么写?
| stkcd | year | asset |
1 | 2006 | 2.60576E+11 |
1 | 2007 | 3.52539E+11 |
1 | 2008 | 4.7444E+11 |
1 | 2009 | 5.87811E+11 |
1 | 2010 | 7.2761E+11 |
1 | 2011 | 1.25818E+12 |
1 | 2012 | 1.60654E+12 |
1 | 2013 | 1.89174E+12 |
2 | 2006 | 48507917571 |
2 | 2007 | 1.00094E+11 |
2 | 2008 | 1.19237E+11 |
2 | 2009 | 1.37609E+11 |
2 | 2010 | 2.15638E+11 |
2 | 2011 | 2.96208E+11 |
2 | 2012 | 3.78802E+11 |
2 | 2013 | 4.79205E+11 |
4 | 2006 | 204304637.7 |
4 | 2007 | 169822594 |
4 | 2008 | 167810585.2 |
4 | 2009 | 230512058.7 |
4 | 2010 | 184219435.7 |
4 | 2011 | 196307219.5 |
4 | 2012 | 192913568.9 |
5 | 2006 | 1528293792 |
5 | 2007 | 1457023885 |
5 | 2008 | 1389031248 |
5 | 2009 | 1319203896 |
5 | 2010 | 1295654843 |
5 | 2011 | 1260586163 |
5 | 2012 | 1319702418 |
6 | 2006 | 2918925351 |
6 | 2007 | 5568431162 |
6 | 2008 | 5921442330 |
6 | 2009 | 7272027535 |
6 | 2010 | 8568302263 |
6 | 2011 | 8321974063 |
6 | 2012 | 9343430260 |
6 | 2013 | 9968160025 |