topic How to change dataset like this in SAS Procedures

How to change dataset like this

George_S — Wed, 11 Apr 2012 21:43:27 GMT

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

Re: How to change dataset like this

Linlin — Wed, 11 Apr 2012 22:08:28 GMT

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