SAS Financial Functions

SAS Compound Function Example

What is it?

The compound function can be used to compute any of the following from a compounding interest computation:
Amount:
Future Value:
Rate
Number of Periods

Syntax:

Compound(Amount, Future Value, Rate, Number of Periods);

SAS Compound Function:

SAS Compound Example:

Data work.my_data_file;

    Result_1 = Compound(2000, .,0.09/12,30);
    Result_2 = Compound(., 2502.5435276,0.09/12,30);
    Result_3 = Compound(2000, 2502.5435276, ., 30);
    Result_4 = Compound(2000, 2502.5435276,0.09/12,.);

Run;

What's happening in the script above?

The above compound examples are each calculating the missing element/parameter in the compound function.

Compound Function Examples:

Variable	Input	Output	Description
Result_1	2000, .,0.09/12,30	2502.5435276	Function Returned the Future Value
Result_2	., 2502.5435276,0.09/12,30	2000	Function Returns Amount
Result_3	2000, 2502.5435276, ., 30	.0075	Function Returns the Rate
Result_4	2000, 2502.5435276,0.09/12,.	30	Function Returns the number of periods

Connect via LinkedIn

Kevin Regan

Have an article, idea, found a typo, want to contribute? Shoot me an email Here

Below are links to some Udemy Data Science Courses. I've been using Udemy for a number of years now, and I've found their courses super helpful, maybe you will also.