表格部分见下:
Stkcd | Accper | 年初年末平均总资产 | 财务杠杆 |
1 | 2003/12/31 | 1.79509E+11 | 0.97943965 |
1 | 2004/12/31 | 1.9887E+11 | 0.977068166 |
1 | 2005/12/31 | 2.1683E+11 | 0.977998775 |
1 | 2006/12/31 | 2.4145E+11 | 0.975153288 |
1 | 2007/12/31 | 3.0665E+11 | 0.963107487 |
1 | 2008/12/31 | 4.1349E+11 | 0.965431279 |
1 | 2009/12/31 | 5.31126E+11 | 0.965176549 |
1 | 2010/12/31 | 6.57509E+11 | 0.954349268 |
Stkcd | Reptdt | 独董比例 |
1 | 2003/12/31 | 0.214285714 |
1 | 2004/12/31 | 0.384615385 |
1 | 2005/12/31 | 0.285714286 |
1 | 2006/12/31 | 0.307692308 |
1 | 2007/12/31 | 0.285714286 |
1 | 2008/12/31 | 0.285714286 |
1 | 2009/12/31 | 0.333333333 |
Stkcd | Reptdt | D0301b | D0401b |
1 | 2003-12-31 | 男 | 52 |
1 | 2004-12-31 | 男 | 62 |
1 | 2010-12-31 | 男 | 62 |
1 | 2014-12-31 | 男 | 61 |
1 | 2015-12-31 | 男 | 62 |
1 | 2002-12-31 | 男 | 56 |
2 | 2002-12-31 | 男 | 51 |
已经像这样导入了一张表格:
proc import out=test.basic datafile="C:\a.xlsx" DBMS=xlsx replace;run;
data basic; set test.basic;run;
请问接下来我该怎么写呀?
万分感谢!