Hello SAS community, I need a bit of help with the following problem. I am trying to calculate the the break even interest rate on a standard loan, in essence I am trying to goal seek for an interest rate that will result in an net present value of interest income equal to zero. To solve for this rate I am trying to use Proc Model from SAS/ETS. However, when I run the code I receive the following error message: "1. ERROR: There are no model parameters declared. Cannot perform requested FIT task." I do not know what this error is telling me. The code I am running is below: data loan_characteristics; input principal interest_rate months annual_fixed_cost cost_of_capital; cards; 25000 0.05 12 500 0.1 ; run; data loan_profit; set loan_characteristics; npv_interest_income = 0; do m = 1 to months; interest_income = principal*(interest_rate/12); npv_interest_income = npv_interest_income + (interest_income - annual_fixed_cost/12)/(1+cost_of_capital/12)**m; output; end; run; data goal; npv_interest_income = 0; run; proc model data=loan_profit outmodel=loan_profitModel; npv_interest_income = npv_interest_income + (interest_income - annual_fixed_cost/12)/(1+cost_of_capital/12)**m; fit npv_interest_income / outest=demest; solve interest_rate / estdata=demest data=goal solveprint; run;
... View more