working through columns

[Dany1]

Hi!

I have got a variable (v1) like this:

v1

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!

[Kurt_Bremser · Accepted solution]

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

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