topic Re: Moving one row up in SAS Procedures

Moving one row up

My_SAS — Wed, 02 Nov 2011 11:37:00 GMT

I am havig a variable like this

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

no New_no

1 2

2 3

3 4

4 5

5 .

art297 — Wed, 02 Nov 2011 12:26:28 GMT

here is one way:

data have;

input no;

cards;

;

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 — Wed, 02 Nov 2011 13:34:56 GMT

Hi ... another approach ...

data want;

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

run;

PeterPanPan — Wed, 15 May 2013 03:16:36 GMT

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!