请教各位sas高手,我有一个数据集A:
| Startdate | Enddate | Var3 | Var4 |
1 | 1 January 2013 | 31 December 2013 | 10 | 100 |
2 | 1 July 2013 | 30 June 2014 | 20 | 200 |
想要根据Startdate和Enddate两个变量来进行拆分,若某条记录的这两个变量跨年,则拆分成两条记录,同时:Var3在两条记录中不变,而Var4则根据新的两条记录中的startdate和enddate起止长度进行分摊,即,得到数据集B:
| Startdate | Enddate | Var3 | Var4 |
1 | 1 January 2013 | 31 December 2013 | 10 | 100 |
2 | 1 July 2013 | 31 December 2013 | 20 | 100 |
3 | 1 January 2014 | 30 June 2014 | 20 | 100 |
请指教!