DATA Step, Macro, Functions and more

loops

Accepted Solution Solved
Reply
Contributor
Posts: 31
Accepted Solution

loops

I want to do using loops

 

Hi, i have below data

p=100000

interest=10%

 will be the total amount after 4 years 

i want below screen result

 

YearPrincipalinterestsum
11000000.1110000
2110000.112100
3121000.113310
4133100.114641

Accepted Solutions
Solution
‎07-03-2017 10:21 AM
Super User
Posts: 6,946

Re: loops


shivamarrora0 wrote:
Thanks for the explanation , if possible can you please tell the code

I already supplied the code.

I usually solve such problems a little differently, though:

data test;
base = 100000;
int = .10;
do i = 0 to 5;
  p = base * (1 + int) ** i;
  output;
end;
run;

With that formula, you can calculate the value for any year in one single step.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Super User
Posts: 6,946

Re: loops

Please show the code you already have (as this "problem" is really simple), and where it does not meet your expectations.

If you get unexpected messages in the log, post the log of the whole step.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 31

Re: loops

i  just started learning SAS.

 

data test;

p=100000;

int=.10;

do i = 1 to 5;

p+p*int;

 

end;

run;

 

this code will over right the orginal data

Contributor
Posts: 31

Re: loops

i  just started learning SAS.
 
data test;
p=100000;
int=.10;
do i = 1 to 5;
p+p*int;
 
end;
run;
 
this code will over right the original data
Super User
Posts: 6,946

Re: loops

[ Edited ]

shivamarrora0 wrote:

i  just started learning SAS.

 

data test;

p=100000;

int=.10;

do i = 1 to 5;

p+p*int;

 

end;

run;

 

this code will over right the orginal data


When you run a data step that does not have an explicit output statement, SAS will do one everytime it reaches the end of a data step iteration. See it as a hidden "output" right before the run statement.

If you do not have a statement that let's SAS iterate automatically (like a set that reads from a dataset), then SAS will only do one iteration, and that's it.

So in your case, SAS performs the loop, and then writes one observation with the final values.

To get a series of observations, add the explicit output statement:

data test;
p = 100000;
int = .10;
do i = 1 to 5;
  p + p * int;
  output;
end;
run;

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 31

Re: loops

Thanks for the explanation , if possible can you please tell the code
Solution
‎07-03-2017 10:21 AM
Super User
Posts: 6,946

Re: loops


shivamarrora0 wrote:
Thanks for the explanation , if possible can you please tell the code

I already supplied the code.

I usually solve such problems a little differently, though:

data test;
base = 100000;
int = .10;
do i = 0 to 5;
  p = base * (1 + int) ** i;
  output;
end;
run;

With that formula, you can calculate the value for any year in one single step.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 192 views
  • 0 likes
  • 2 in conversation