Attempt two.
DATA HAVE;
infile datalines delimiter=',';
input contr_renew_month product $ payment_term $ count amt_policy amt_month terms amt_contr_ren;
datalines;
1, car, half, 100, 45640, 38.03, 6, 22820
1, car, year, 150, 65844, 36.58, 12, 65844
1, car, qrt, 25, 9344, 31.15, 4, 3114.67
1, car, mnth, 350, 109994, 26.19, 1, 9166.17
2, car, half, 150, 59045, 32.80, 6, 29522.50
2, car, year, 150, 66899, 37.17, 12, 66899.00
2, car, qrt, 150, 55555, 30.86, 4, 18518.33
2, car, mnth, 150, 55874, 31.04, 1, 4656.17
;
RUN;
I want to create an extra column --> amt_payment.
In 'contract_renewal_mont' 1 we don't just receive the payments of the policies where the contract is renewed. We also recieve payments of customers who pay in terms. In this example in month 1:
SUM(amt_contr_renewal) of 'half' of contr_renew_mnth 6 when then customer has a payment_term 'half'
SUM(amt_contr_renewal) of 'qrt' of contr_renew_mnth 4,7,10 when then customer has a payment_term 'qrt'
SUM(amt_contr_renewal) of 'mnth' of contr_renew_mnth 2 - 12 when then customer has a payment_term 'mnth'
English is not my native language, so I hope you understand my intentions.
... View more