BookmarkSubscribeRSS Feed
Calcite | Level 5

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?






Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 1 in conversation