topic Re: swaping missing values in SAS Programming

swaping missing values

Rahul_SAS — Fri, 07 Oct 2016 06:24:44 GMT

Hi Experts,
I need to swap missing value with above value so please help me in the same.

data abc;
input sub $ score;
datalines;
001 120
001 .
002 220
001 .
002 .
003 .
003 230
;
run;
data abc1;
set abc;
score2=lag(score);
if score = . then score=lag(score);
run;

WANT
001 120
001 120
002 220
001 220
002 220
003 220
003 230

thnx

Re: swaping missing values

Tom_C_Mortensen — Fri, 07 Oct 2016 06:38:30 GMT

Hi Rahul

below can do the trick

data abc1;

retain score;

set abc(rename=(score=score2));

if score2 ne . then score=score2;

drop score2;

run;

Re: swaping missing values

Kurt_Bremser — Fri, 07 Oct 2016 06:46:25 GMT

Try this:

data have;
input sub $ score;
datalines;
001 120
001 .
002 220
001 .
002 .
003 .
003 230
;
run;

data want;
set have;
retain x1;
if score = .
then score = x1;
else x1 = score;
drop x1;
run;

proc print noobs;
run;

Result:

sub    score

001     120 
001     120 
002     220 
001     220 
002     220 
003     220 
003     230

Re: swaping missing values

Rahul_SAS — Fri, 07 Oct 2016 15:21:47 GMT

Hi KurtBremser,

Thank you for the help.

I have one more point, if the first observation has a missing value then how will it work??

thnx

rahul