Determine lag of muliple variables in a dataset

[WAL83]

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.

[art297 · Accepted solution]

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;

[WAL83]

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

array lagvars(*) A1 A2 A3;