topic Determine lag of muliple variables in a dataset in SAS Programming

Determine lag of muliple variables in a dataset

WAL83 — Mon, 29 Aug 2011 16:43:40 GMT

I am trying to calculate lag values of multiple variables in a dataset by using two arrays but can't get it to work. Does anyone have any ideas? See attached. Thanks.

Determine lag of muliple variables in a dataset

art297 — Mon, 29 Aug 2011 16:55:44 GMT

I think you are trying to do something like:

data data1 (drop=i);

set data0;

by id;

array vars {*} A B C;

array lagvars(3);

do i = 1 to 3;

lagvars(i)=lag(vars(i));

if first.id then call missing(lagvars(i));

end;

run;

Determine lag of muliple variables in a dataset

WAL83 — Mon, 29 Aug 2011 17:22:38 GMT

That worked perfectly, although I changed the second array to hardcode the lag variable names. Thanks!

array lagvars(*) A1 A2 A3;