SAS EG Compounding Interest Calculation

[SurenderSoni]

Hi All,

I have a query regarding compounding interest rates calculation using fluctuating rates. Please see attached excel where in row 11 has calculated amount using excel formulas - need to replicate this in SAS EG.

Any help is much appreciated and its little urgent as well 🙂

Regards,

Surender

[PeterClemmensen]

Most users don't want to download Excel files. Post your data directly in your message in a usable form, please.

[SurenderSoni]

[ballardw]

What does the SAS data set you have look like?

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.