working through columns

Dany1 — Tue, 16 Oct 2018 11:08:06 GMT

Hi!

I have got a variable (v1) like this:

311

1066

4710

4715

and I would like to create another variable (v2)

v2 v1

0 311

312 1066

1067 4710

4711 4715

How can I do it?

Thanks!

Re: working through columns

Kurt_Bremser — Tue, 16 Oct 2018 11:24:49 GMT

In a data step, use the lag() function:

v2 = lag(v1);
if v2 = . /* first observation */
then v2 = 0;
else v2 = v2 + 1;