topic Re: SAS EG Compounding Interest Calculation in SAS Enterprise Guide

SAS EG Compounding Interest Calculation

SurenderSoni — Tue, 01 Sep 2020 11:37:45 GMT

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

Re: SAS EG Compounding Interest Calculation

PeterClemmensen — Tue, 01 Sep 2020 11:45:44 GMT

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

Re: SAS EG Compounding Interest Calculation

SurenderSoni — Tue, 01 Sep 2020 11:52:37 GMT

Re: SAS EG Compounding Interest Calculation

ballardw — Tue, 01 Sep 2020 15:01:28 GMT

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-data-AKA-generate/ta-p/258712 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.