Moving one row up

[My_SAS]

I am havig a variable like this 

no

1

2

3

4

5

I want to create a new varible to move uprow up..

no New_no

1  2

2  3

3  4

4  5

5  .

[art297]

here is one way:

data have;

  input no;

  cards;

1

2

3

4

5

;

data want;

  set have end=lastone;

  set have ( firstobs = 2 keep = No rename = (No = New_No) )

      have (      obs = 1 drop = _all_                     );

New_No = ifn(  lastone, (.), New_No );

run;

[MikeZdeb]

Hi ... another approach ...

data want;

merge have have (firstobs=2 rename=(no=new_no));

run;

[PeterPanPan]

If the data set contains only these two variables, I would do it like this:

*step 1. Delete the first row;

data output1;

set input;

if first.no then delete;

rename no=new_no;

run;

*step 2. Build new variable;

data output2;

set ouput1;

no=lag(new_no);

run;

Then deal with the first obs of no and last obs of new_no.

HTH!