topic Re: LAG of a computed variable in SAS Programming

LAG of a computed variable

Taliah — Tue, 05 Mar 2019 09:59:27 GMT

I have a data set with variable a. I need to create variable b that is equal in line 1 to (1+a) and in each of the following lines to the value created for b in the previous line multiplied by (1+a) (a of the current line). I tried different things and each time run into another problem. The problem is how ot get the lag of variable b I just computed in the previous line. I tried using retain, and computing a lag variable outside the if statement, and it still does not work. For example:

data test2;

set test;

retain b;

lagb = lag(b);

if _N_ = 1 then b = sum(1,a);

else b= lagb * sum(1,a);

run;

Re: LAG of a computed variable

ChrisNZ — Tue, 05 Mar 2019 10:05:48 GMT

Please provide example data and expected output for that data.

Re: LAG of a computed variable

RW9 — Tue, 05 Mar 2019 10:16:51 GMT

To continue with that approach you would need two datasteps, one to calculate the variable, the second to do the lag. You cannot use lag() and variables which are not fixed. There are other ways, such as retain, and merging on obs=obs+1. However without test data in the form of a datastep we cannot provide anything.

Re: LAG of a computed variable

Astounding — Tue, 05 Mar 2019 10:58:16 GMT

Depending on your objective here, it is possible that a very simple program will do. Try:

data test2;
set test;
retain b 1;
b = b * sum(1, a);
run;

If that gives you the right result, great. If not, you can still get the lag you are asking for. Use:

data test2:
lagb=b;
set test;
retain b;
if _n_=1 then b=sum(1, a);
else b=lagb * sum(1, a);
run;

Re: LAG of a computed variable

Taliah — Tue, 05 Mar 2019 11:06:39 GMT

Thank you for your replys. I simplified the data. input data:

required output:

a b

10 11

2 33

4 165

8 1485

5 8910

As explained above, b is equal in line 1 to (1+a) and in each of the following lines to the value created for b in the previous line multiplied by (1+a) (a of the current line).

Re: LAG of a computed variable

Taliah — Tue, 05 Mar 2019 11:13:36 GMT

Thank you! Looks like the first code you wrote does the job.

I see what you did with the retain b and using that instead of lag.

Does the retaon 1 retain line 1?

Thank you again!

Re: LAG of a computed variable

Astounding — Tue, 05 Mar 2019 15:03:23 GMT

This statement:

retain b 1;

both retains B and gives it an initial value of 1 "Initial value" means at the very beginning of the DATA step, before reading in any of the data. It does NOT mean at the beginning of each observation.

Re: LAG of a computed variable

Taliah — Wed, 06 Mar 2019 13:31:21 GMT

Thank you for all your help!