How to change dataset like this

[George_S]

how to get need from have(move variable y upward two cells)  in one data step.

Thanks!

data have;

input x y;

cards;

1

2

3 a

4 b

5 c

;

run;

need:

x y

1 a

2 b

3 c

4

5

[Linlin]

Hi George,

Try this:

data have;

infile cards missover;

input x y $;

cards;

1

2

3 a

4 b

5 c

;

run;

data need;

merge have(keep=x) have(firstobs=3 keep=y);

run;

proc print;run;

Linlin