/*sas程序*/;
%let p=300000;
%let m_rate=0.0062;
data a;
loans_dt='13mar10'd;
end_dt='13mar19'd;
month=intck('month',loans_dt,end_dt);
m_repay=0;
cumpu_repay=0;
n_month=month;
do i=1 to month by 1;
m_repay=(&p/n_month)+(&p-cumpu_repay)*&m_rate;
file 'D:\programs\sas\houserepay.dat';
put month= m_repay= ;
cumpu_repay=cumpu_repay+m_repay;
month=month-1;
end;
run;
month=108 m_repay=4637.7777778
month=107 m_repay=4609.0235556
month=106 m_repay=4580.4476095
month=105 m_repay=4552.0488343
month=104 m_repay=4523.8261316
month=103 m_repay=4495.7784095
month=102 m_repay=4467.9045834
month=101 m_repay=4440.203575
month=100 m_repay=4412.6743128
month=99 m_repay=4385.3157321
month=98 m_repay=4358.1267745
month=97 m_repay=4331.1063885
month=96 m_repay=4304.2535289
month=95 m_repay=4277.5671571
month=94 m_repay=4251.0462407
month=93 m_repay=4224.689754
month=92 m_repay=4198.4966775
month=91 m_repay=4172.4659981
month=90 m_repay=4146.5967089
month=89 m_repay=4120.8878093
month=88 m_repay=4095.3383049
month=87 m_repay=4069.9472074
month=86 m_repay=4044.7135347
month=85 m_repay=4019.6363108
month=84 m_repay=3994.7145657
month=83 m_repay=3969.9473354
month=82 m_repay=3945.3336619
month=81 m_repay=3920.8725932
month=80 m_repay=3896.5631831
month=79 m_repay=3872.4044914
month=78 m_repay=3848.3955835
month=77 m_repay=3824.5355309
month=76 m_repay=3800.8234106
month=75 m_repay=3777.2583055
month=74 m_repay=3753.839304
month=73 m_repay=3730.5655003
month=72 m_repay=3707.4359942
month=71 m_repay=3684.449891
month=70 m_repay=3661.6063017
month=69 m_repay=3638.9043426
month=68 m_repay=3616.3431357
month=67 m_repay=3593.9218083
month=66 m_repay=3571.6394931
month=65 m_repay=3549.4953282
month=64 m_repay=3527.4884572
month=63 m_repay=3505.6180287
month=62 m_repay=3483.883197
month=61 m_repay=3462.2831211
month=60 m_repay=3440.8169658
month=59 m_repay=3419.4839006
month=58 m_repay=3398.2831004
month=57 m_repay=3377.2137452
month=56 m_repay=3356.27502
month=55 m_repay=3335.4661149
month=54 m_repay=3314.7862249
month=53 m_repay=3294.2345503
month=52 m_repay=3273.8102961
month=51 m_repay=3253.5126723
month=50 m_repay=3233.3408937
month=49 m_repay=3213.2941802
month=48 m_repay=3193.3717563
month=47 m_repay=3173.5728514
month=46 m_repay=3153.8966997
month=45 m_repay=3134.3425402
month=44 m_repay=3114.9096164
month=43 m_repay=3095.5971768
month=42 m_repay=3076.4044743
month=41 m_repay=3057.3307666
month=40 m_repay=3038.3753158
month=39 m_repay=3019.5373888
month=38 m_repay=3000.816257
month=37 m_repay=2982.2111962
month=36 m_repay=2963.7214868
month=35 m_repay=2945.3464136
month=34 m_repay=2927.0852658
month=33 m_repay=2908.9373372
month=32 m_repay=2890.9019257
month=31 m_repay=2872.9783338
month=30 m_repay=2855.1658681
month=29 m_repay=2837.4638397
month=28 m_repay=2819.8715639
month=27 m_repay=2802.3883602
month=26 m_repay=2785.0135524
month=25 m_repay=2767.7464684
month=24 m_repay=2750.5864403
month=23 m_repay=2733.5328043
month=22 m_repay=2716.5849009
month=21 m_repay=2699.7420745
month=20 m_repay=2683.0036737
month=19 m_repay=2666.3690509
month=18 m_repay=2649.8375628
month=17 m_repay=2633.4085699
month=16 m_repay=2617.0814368
month=15 m_repay=2600.8555319
month=14 m_repay=2584.7302276
month=13 m_repay=2568.7049002
month=12 m_repay=2552.7789298
month=11 m_repay=2536.9517004
month=10 m_repay=2521.2225999
month=9 m_repay=2505.5910197
month=8 m_repay=2490.0563554
month=7 m_repay=2474.618006
month=6 m_repay=2459.2753744
month=5 m_repay=2444.0278671
month=4 m_repay=2428.8748943
month=3 m_repay=2413.8158699
month=2 m_repay=2398.8502115
month=1 m_repay=2383.9773402