I would like to convert an excel formula to SAS. Below is an example:   Values: Rate 5.00% Present Value 20,000 Term 36 Average Life 24 Payment (Excel) 599.42 Average Balance (Excel) 13,879.62   EXCEL Calc  (PMT): Payment:   =ROUND(PMT(0.05/12,36,-20000,0),2)   EXCEL Calc: : Average Future Balance (array formula Press Ctrl+Shift+Enter) :   =IFERROR(AVERAGE(FV(0.05/12,ROW(INDIRECT("1:"&24))-1,(ROUND(PMT(0.05/12,36,-20000,0),2)),-20000)),0)   ... View more