s**********y 发帖数: 38 | 1 id beganDate endDate pattern
101 3/5/2006 3/10/2006
101 1
101 2
101 3
101 1
101 3/5/2006 3/10/2006 1
102 3/7/2006 3/11/2006 2
102 3/7/2006 3/11/2006 2
102 3/7/2006 3/11/2006 3
102 3/7/2006 3/11/2006 1
102 3/7/2006 3/11/2006 1
103 5/12/2007 5/24/2007 .
103 . .
103 . 2
103 . 2
103 . 3
103 . 3
103 . 3
103 5/12/2007 1
103 1
103 1
103 1
103 1
103 5/12/2007 5/24/2007 .
104 5/14/2007 5/20/2007 2
104 3
104 1
104 2
104 3
104
新手学SAS 请帮忙呀、事先感谢各位。
如上数据,要得到下面的数据。
1.要把没有填的beganDate,endDate 填充。2.根据beganDate, endDate产生一
Variable,date,显示每天。
3.得到多少天能到达pattern 1. pattern 1 连续3 天或者是在service 的最后才算。
所以id103 是7天,而不是3 天。另外id104 没有最后到达pattern 1, need to be
excluded.
id beganDate endDate date pattern days
101 3/5/2006 3/10/2006 3/5/2006 .
101 3/5/2006 3/10/2006 3/6/2006 1
101 3/5/2006 3/10/2006 3/7/2006 2
101 3/5/2006 3/10/2006 3/8/2006 3
101 3/5/2006 3/10/2006 3/9/2006 1 4
101 3/5/2006 3/10/2006 3/10/2006 1
102 3/7/2006 3/11/2006 3/7/2006 2
102 3/7/2006 3/11/2006 3/8/2006 2
102 3/7/2006 3/11/2006 3/9/2006 3
102 3/7/2006 3/11/2006 3/10/2006 1 3
102 3/7/2006 3/11/2006 3/11/2006 1
103 5/12/2007 5/24/2007 5/12/2007 .
103 5/12/2007 5/24/2007 5/13/2007 .
103 5/12/2007 5/24/2007 5/14/2007 2
103 5/12/2007 5/24/2007 5/15/2007 2
103 5/12/2007 5/24/2007 5/16/2007 1
103 5/12/2007 5/24/2007 5/17/2007 1
103 5/12/2007 5/24/2007 5/18/2007 3
103 5/12/2007 5/24/2007 5/19/2007 1 7
103 5/12/2007 5/24/2007 5/20/2007 1
103 5/12/2007 5/24/2007 5/21/2007 1
103 5/12/2007 5/24/2007 5/22/2007 1
103 5/12/2007 5/24/2007 5/23/2007 1
103 5/12/2007 5/24/2007 5/24/2007 .
104 5/14/2007 5/20/2007 5/14/2007 2
104 5/14/2007 5/20/2007 5/15/2007
104 5/14/2007 5/20/2007 5/16/2007 3
104 5/14/2007 5/20/2007 5/17/2007 1
104 5/14/2007 5/20/2007 5/18/2007 2
104 5/14/2007 5/20/2007 5/19/2007 3
104 5/14/2007 5/20/2007 5/20/2007 |
|