还请各位高手多多给予点评~

Try the following code and look at the results carefully.
You may need to do some futher calculations.


/* sort the data set by id LNNO and term */
proc sort data=t_plan;
    by lnno term;
run;
proc sort data=t_repay;
       by lnno_repay repay_term;
run;
data t_plan_repay;    /* merge the two data sets */
     merge t_plan t_repay (rename=(lnno_repay=lnno));
         by lnno;
         drop repayamt planrepayamt plansource;
run;

/* calculate the balance and days of delay at last event */
data t_lastDate; /* calculate the balance and days of delay */
       set t_plan_repay;
           balance = repay_cum - plan_cum;
           delay = repaydate - planrepaydate;
           by lnno;
           if last.lnno;
run;
data t_delay; /* output the results */
     set t_lastDate;
         if delay > 0 then output;
run;

十分感谢您的回答
根据实际的业务情况,对于存在计划贷款本身来说,如果该贷款中间逾期,而最后总金额到截止贷款到期时还完,则该贷款其实同样算作逾期贷款.
例如某贷款在还款期内,中间出现逾期delay>0,最后到贷款截止日期全部还清,则该贷款同样算作逾期.
所以该代码在计算逾期天数部分还需要调整.

对于计算中间逾期现象,您看有什么方法可以用SAS来实现?
多谢指点.

先去掉 by lnno; if first.lnno; 这两句, and change dataset name to t_Delay_by_term;
这样可计算出每一term的delay。然后在看什么是你想要的结果。

data t_Delay_by_term;
       set t_plan_repay;
           balance = repay_cum - plan_cum;
           delay = repaydate - planrepaydate;
     *   by lnno;
     *   if last.lnno;
run;