I am new to the community and interested SAS capabilities. I would like to run multiple amortization schedules on approximately 500,000 loans. There are various loan types: commercial, residential, fixed rate, floating, balloons, auto, etc. Important output needs: + principal and interest payments monthly + Must be able to include borrower prepayments IE: 10% of each loan will prepay annually + Need present value of cash flow for each loan based on a discount rate that is different from the borrower loan rate + Need to run the analysis multiple times (based on different prepay speeds and discount rates). + Need to group monthly results into categories IE: Mortgage loan totals, car loan totals, etc By my rough estimate, the project includes 5 to 9 billion calculations (principal, interest and prepayments monthly). I am currently using Excel on a smaller scale, but it can't handle this large data set and number of calculations. I have never used SAS and would like some advice: + is SAS a good tool to address this project? + can I run it on a desktop PC? + Anything else I should consider? Thanks in advance for all replies. Jim
... View more