id | loan2007 | loan2006 | loan2005 | oea2007 | oea2006 | oea2005 | tfa2007 | tfa2006 | tfa2005 |
1 | 867612 | 775929 | 775128 | 1362418 | 1095597 | 1077513 | 34116 | 29690 | 29813 |
2 | 544985 | 439524 | 423339 | 630490 | 532801 | 521295 | 12697 | 10676 | 11073 |
3 | 1856464 | 1570455 | 1558773 | 2133467 | 1695495 | 1560477 | 45015 | 37773 | 41738 |
4 | 673996 | 589979 | 596252 | 1534356 | 1287148 | 1197615 | 27582 | 22626 | 23850 |
5 | 431735 | 412387 | 413394 | 220441 | 120866 | 150119 | 11983 | 11221 | 15911 |
6 | 714079 | 578962 | 581106 | 631138 | 564796 | 541616 | 23267 | 18201 | 19080 |
7 | 17994 | 15358 | 16061 | 55693 | 47467 | 49888 | 13 | 12 | 32 |
其中id列表示样本点编号,2007-2006-2005表示年号,loan表示贷款,请问我要怎么样才能将其转化为三个变量loan ,oea,tfa.
我使用reshape long loan oea tfa ,i(id) j(year),但是没有成功,返回结果为unrecognized command: label。求求大家了?