topic Moving value from one row to another in SAS Procedures

Moving value from one row to another

jerry898969 — Mon, 02 May 2011 13:33:05 GMT

I have a simple question that I can't seem to figure out.

I have data like this

2000 1 2
. 1 3
. 1 4
2001 2 1
. 2 2
2002 3 1
. 3 2
. 3 3

How can I make the year show up for every row like this

2000 1 2
2000 1 3
2000 1 4
2001 2 1
2001 2 2
2002 3 1
2002 3 2
2002 3 3

Thank you

Re: Moving value from one row to another

art297 — Mon, 02 May 2011 13:54:10 GMT

Jerry,

The are a number of ways. The one I usually use is:
[pre]
data want (drop=hold);
set have;
retain hold;
if not(missing(year)) then hold=year;
year=ifn(missing(year),hold,year);
run;
[/pre]
HTH,
Art

Re: Moving value from one row to another

SPR — Mon, 02 May 2011 13:57:38 GMT

Hello Jerry898969,

This is a solution:
[pre]
data i;
input y b c;
datalines;
2000 1 2
. 1 3
. 1 4
2001 2 1
. 2 2
2002 3 1
. 3 2
. 3 3
run;
data r;
retain y0;
set i;
if y NE . then y0=y;
else y=y0;
drop y0;
run;
[/pre]
Sincerely,
SPR

Re: Moving value from one row to another

jerry898969 — Mon, 02 May 2011 13:58:21 GMT

art,

That was it. Thank you so much

Re: Moving value from one row to another

jerry898969 — Mon, 02 May 2011 13:58:56 GMT

SPR,

Thank you for your reply.

Jerry