Given the origination balance, interest rate, and term, is there a function in SAS that would yield balance as of a future date? I have researched the mort and finance functions, but it doesn't seem that those would work. Thanks!
proc loan
http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_loan_sect010.h...
I was able to use the finance function with "CUMPRINC" to back into this number. Thanks for the help everyone!
pay_curr_bal=pay_Orig_Amt2+finance('CUMPRINC',pay_int_rt/12,pay_ori_term,pay_Orig_Amt2,1,loan_age+1);
And if you have SAS/ETS available then Proc Loan may be of interest for printing actual amortization tables and has a number of other options.
http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_loan_sect007.h...
proc loan is what you want to use.
proc loan start=1998:12; fixed amount=100000 rate=7.5 life=180 schedule=1 label='BANK1, Fixed Rate'; run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Register now!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.