topic Re: Assign Values for Missings in SAS Procedures

Assign Values for Missings

PeterPanPan — Wed, 15 May 2013 03:37:15 GMT

Hi there,

I have a data set as the picture shows below. For variable R, it has a lot of missing values. What I want to do is to assign the existing value to all the previous blanks. For example, assign 1.0219 to observation 1-10 of R, and assign 0.9598 to observations 12 to 20. Finally the variable R will have 0 missing values. Any ideas?

TIA!

Re: Assign Values for Missings

Ksharp — Wed, 15 May 2013 05:08:34 GMT

OK.

data have ;
input a b;
cards;
1 .
2 .
3 4
4 5
5 .
6 .
7 .
8 9
;
run;
data want;
do until(not missing(b));
 set have;
end;
c=b;
do until(not missing(b));
 set have; output;
end;
run;

Ksharp

Re: Assign Values for Missings

PeterPanPan — Sun, 19 May 2013 19:22:33 GMT

Thank you so much, Ksharp, you solved my problem!