- 阅读权限
- 255
- 威望
- 0 级
- 论坛币
- 157 个
- 通用积分
- 0
- 学术水平
- 7 点
- 热心指数
- 7 点
- 信用等级
- 5 点
- 经验
- 4824 点
- 帖子
- 57
- 精华
- 0
- 在线时间
- 124 小时
- 注册时间
- 2016-1-13
- 最后登录
- 2019-6-20
|
- data borrow;
- input no date_borrow months first second third;
- informat date_borrow yymmdd10. first yymmdd10. second yymmdd10. third yymmdd10.;
- format date_borrow yymmdd10. first yymmdd10. second yymmdd10. third yymmdd10.;
- cards;
- 1 2012/12/03 3 2013/01/03 2013/02/03 2013/03/03
- 2 2013/03/02 6 2013/04/02 2013/05/02 2013/06/02
- 3 2013/03/29 6 2013/04/29 2013/05/29 2013/06/29
- 4 2013/06/03 12 2013/07/03 2013/08/03 2013/09/03
- ;
- run;
- data sort(keep=k);
- set borrow;
- format k yymmdd10.;
- k=first;
- output;
- k=second;
- output;
- k=third;
- output;
- run;
- data index;
- set borrow(keep=no date_borrow);
- run;
- proc sort data=sort;
- by k;
- run;
- proc sort data=index;
- by date_borrow;
- run;
- proc sql noprint;
- create table result as select * from sort , index;
- quit;
- proc sort data=result;
- by no;
- run;
- data result;
- set result;
- by no;
- if date_borrow>=k;
- run;
- data result;
- set result;
- by no;
- retain return;
- if first.no then return=0;
- return+1/3;
- if last.no;
- run;
- proc sort data=index;
- by no;
- run;
- data result(keep=no return);
- merge result index;
- by no;
- if return=. then return=0;
- run;
复制代码
|
|