## Increment a cost by 5% for 4 series

Solved
Super Contributor
Posts: 409

# Increment a cost by 5% for 4 series

What is the best way (formula only) to show  an increment by 5%.  So for example cost = 23, what is the best formaula to use to also show 4 increments by 5%.  So cost1 = cost + cost * 0.05 and cost2 = cost + cost*0.1 .. etc... Thanks

Accepted Solutions
Solution
‎10-02-2014 03:46 PM
Posts: 1,270

## Re: Increment a cost by 5% for 4 series

data have;

array c{*} cost1-cost4;

cost=23;

do i=1 to 4;

p+0.05;

c{i}=cost*(1+p);

end;

run;

All Replies
Super User
Posts: 23,727

## Re: Increment a cost by 5% for 4 series

math 101

cost(1)= cost(1.04)

cost(2)=cost(1.04)*(1.04)

cost(3)=cost(1.04)*(1.04)*(1.04)

..

cost(n)=cost(1.04)**n

These can also vary slightly depending on when increases are, extra payments and all sorts of variations.

Anyways, there's a whole scheme of SAS finance functions that accomplishes these:

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

EDIT: I assumed a 4% increase for some reason, you can replace that with the relevant amount.

Super Contributor
Posts: 409

## Re: Increment a cost by 5% for 4 series

Yes, but I was hoping to see it in a loop.

Valued Guide
Posts: 2,191

## Re: Increment a cost by 5% for 4 series

A formula is a part of one assignment with one result.

To get 4 answers you need 4 assignnents

Except for a CALL routine like CALL SCAN which derives 3 results in one statement. But to write your own call routine involves more than one statement.

So, what does your request mean.

Cost1 = cost * ( 1+ rate/100) ;

Cost2 = cost1*( 1+ rate/100) ;

Cost3 = cost2*( 1+ rate/100) ;

where rate is 5 for 5%

Super User
Posts: 23,727

## Re: Increment a cost by 5% for 4 series

then what does your data look like and what do you want the output to look like?

Super Contributor
Posts: 409

## Re: Increment a cost by 5% for 4 series

I am trying to see losses based on different cost scenarios so part of a larger formula , cost would be shoiwng as cost1, cost2, cost3, etc..

for example Losses = cost + fees + interest.  I want to see the Losses scenarios if Cost incremented by 5% .. and I want to see it for 4 scenarios.

Super User
Posts: 23,727

## Re: Increment a cost by 5% for 4 series

I don't understand

Solution
‎10-02-2014 03:46 PM
Posts: 1,270

## Re: Increment a cost by 5% for 4 series

data have;

array c{*} cost1-cost4;

cost=23;

do i=1 to 4;

p+0.05;

c{i}=cost*(1+p);

end;

run;

Super Contributor
Posts: 409

## Re: Increment a cost by 5% for 4 series

Thank you ..

🔒 This topic is solved and locked.