stkcd(股票代码)
| year(年) | personid(辨识不同的员工) | tenure(任期)
|
| 1 | 2009 | 30024 | 3 |
| 1 | 2009 | 30025 | 3 |
| 1 | 2010 | 30024 | 4 |
| 1 | 2011 | 30024 | 5 |
| 1 | 2011 | 30026 | 1 |
| 1 | 2012 | 30027 | 1 |
| 2 | 2009 | 50023 | 1 |
| 2 | 2010 | 50023 | 2 |
| 2 | 2010 | 50024 | 1 |
| 2 | 2011 | 50023 | 3 |
| 2 | 2011 | 50024 | 2 |
| 2 | 2012 | 50023 | 4 |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
我的数据是上面这样的.
我现在想要求每个stkcd在每个year的tenure的平均数,tenure的平均数(average_tenure)就是每个stkcd在每个year的所有person的tenure总和再除以person的人数,最后想得到的效果如下:
请问该怎么写sas程序呢??
| stkcd | year | average_tenure |
| 1 | 2009 | |
| 1 | 2010 | |
| 1 | 2011 | |
| 1 | 2012 | |
| 2 | 2009 | |
| 2 | 2010 | |
| 2 | 2011 | |
| 2 | 2012 | |