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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Submit your idea!
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.