DATA Step, Macro, Functions and more

Do LOOPS

Reply
Occasional Contributor
Posts: 7

Do LOOPS

on January 1 of each year,$5000 is invested in an amount .complete the data step with do loop to determine the value of the account after 15 years 1) if a constant annual invest rate of 10% is expected .2)if a compounding annual interest rate of 10 % is expected .?

Super User
Posts: 10,623

Re: Do LOOPS

Posted in reply to Aswin1099

This homework assignment has been posted multiple times here. Use the search function.

When posting a question, always show the effort you have already made (code & log), and where it doesn't do what you expect.

We're not here to support lazy students, but help people who make an honest effort at solving their issue themselves.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Occasional Contributor
Posts: 7

Re: Do LOOPS

Posted in reply to KurtBremser

I have tried this but i think both of them are wrong

 

/*1. (1) DO LOOP- CONSTANT ANNUAL INTEREST RATE OF 10% */


data earning;
do year= 1 to 15;
rate=0.1;
amount+5000;
amount+(amount*0.1);
output;
end;
run;


/*1. (2) DO LOOP- COMPOUNDING ANNUAL INTEREST RATE OF 10% */

data earning2;
do year= 1 to 15;
rate=0.1;
amount+5000;
earned+(amount+earned)*rate;
output;
end;
run;

 

Super User
Posts: 10,623

Re: Do LOOPS

Posted in reply to Aswin1099

And what are the values you would expect?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Occasional Contributor
Posts: 7

Re: Do LOOPS

Posted in reply to KurtBremser
DO LOOPS (1) SIMPLE INTEREST- interest will calculate every year but that interest will add in amount after 15 years
(2) COMPOUND INTEREST-every year interest will add in amount
Super User
Posts: 13,950

Re: Do LOOPS

Posted in reply to Aswin1099

SAS also has a number of financial functions and/or options for the FINANCE function that allow many calculations of this specific type without any looping.

Occasional Contributor
Posts: 7

Re: Do LOOPS

DO LOOPS (1) SIMPLE INTEREST- interest will calculate every year but that interest will add in amount after 15 years

(2) COMPOUND INTEREST-every year interest will add in amount

Ask a Question
Discussion stats
  • 6 replies
  • 313 views
  • 0 likes
  • 3 in conversation