topic Re: LAG function outside of a loop in SAS Programming

LAG function outside of a loop

cw_sas — Sat, 16 Apr 2016 00:10:05 GMT

when i use a DO loop, the LAG function works as follows.

================

data t;
do i=1 to 4;
j=lag(i);
output;
end;
====================

it gives

==========

i j

1 .

2 1

3 2

4 3

=========

however, the following does not.

===========

data t;
i=1;j=lag(i);
output;
i=2;j=lag(i);
output;
i=3;j=lag(i);
output;
i=4;j=lag(i);
output;
run;

=========

it gives

==========
i j

1 .

2 .

3 .

4 .

==========

any idea? thanks.

Reeza — Sat, 16 Apr 2016 00:27:55 GMT

Each lag function creates its own queue so with 4 lag calls versus 1 lag function you will see different behaviour.

This is is a fairly contrived example, what are you actually trying to achieve, or is it for learning purposes.

cw_sas — Sat, 16 Apr 2016 00:51:18 GMT

many thanks.