sas dataset loop to calculate new rows

[koya]

HI,

I have the below requirement and wondering if this can be implemented in simple datastep loop:

will be starting with a simple dataset with two variable

input:

x	y
1	0

logic:

x	y	z
1	0	x+y
prev z	prev y +1	x+y
prev z	prev y +1	x+y

desired output:

x	y	z
1	0	1
1	1	2
2	2	4
4	3	7
7	4	11

[FreelanceReinh · Accepted solution]

Hi @koya,

---

@koya wrote:

... wondering if this can be implemented in simple datastep loop

---

Yes, this is possible. Wondering why you don't just start writing that data step.

Spoiler

data have;
x=1; y=0;
run;

data want;
set have;
do _n_=1 to 5;
  z=x+y;
  output;
  x=z; y+1;
end;
run;

/* Or even simpler: */

data want;
set have;
do y=y to 4;
  z=x+y;
  output;
  x=z;
end;
run;

[Ksharp]

data want;
 x=1;y=0;z=x+y;output;
 do i=1 to 10;
   x=z;y=y+1;z=x+y;output;
 end;
 drop i;
run;

proc print;run;