Hi All,
i am using proc model for solve this problem.
I have a loan amortization with Variable Rate and i want calculate a Index(EVA);i want calculate rate with sum(EVA)=0
I am using proc model.
My problem is a length equation for calculate Index(over 32K or 64k for macrovariable).
In xlsx there are a example (A9:J14) ;in here there are Expression for calculate Amount Capital/Interest Rate etc..
In A19:J25 there are Expression in relation with Rate(c17);i am create all variable in this mode for calculate EVA.
My problem is length variable.
J24 has 6400 character
g24 has 3300 character
Amount capital is a Input for all Index ...and Input for Eva.
Is correct my approach to solve this problem?
