topic Re: The index i in do loop in SAS Programming

The index i in do loop

liyongkai800 — Tue, 19 Jun 2018 13:10:12 GMT

Hi folks,

I have some problem to write the following code by using a do loop. Say I have a column and its name is var1. Now I want to generate the second column and its name is var2, where var2=lag(var1). Similarly, var3=lag(var2) etc.

data want;

set column1;

var2=lag(var1);

var3=lag(var2);

var4=lag(var3);

run;

When I try to use a do loop:

data want;
set column1;
do i=2 to 4;
vari=lag(var(i-1));
run;

Obviously it's not working cuz the i is mixed with the string. Any idea on how to fix it? Thanks.

Re: The index i in do loop

Astounding — Tue, 19 Jun 2018 13:29:23 GMT

Here's one of the missing pieces. You will need to set up an array:

array vars {4} var1-var4;

Then you can refer to elements in the array as vars{i}:

vars{i}=lag(vars(i-1));

What is the "MUST" part of the question? MUST use a DO loop? MUST get the right result? MUST use LAG?

You might be able to solve this without fancy tools, just knowledge of how the DATA step works:

data want;

var4=var3;

var3=var2;

var2=var1;

set have;

retain var1-var4;

run;

Re: The index i in do loop

Kurt_Bremser — Tue, 19 Jun 2018 13:31:43 GMT

Use an array

data want;
set column1;
array vars{4} var1-var4;
do i=2 to 4;
  vars{i}=lag(vars{i-1});
end;
run;

Edit: closed the do block.

Re: The index i in do loop

liyongkai800 — Tue, 19 Jun 2018 14:57:38 GMT

I am fairly new to SAS so I just want to seek all the possibilities. I see array is a very good idea to solve this problem, but I just can't help thinking about do loop. Still, I appreciate your help.