data work.TestData;
input Test09-Test11 Mean;
datalines;
1 2 3 2
. 4 5 4.5
6 . 8 7
8 9 . .
;
run;
data work.TestDataImputed;
set work.TESTDATA;
array Cols(*) Test09-Test11;
if not missing(Mean) then do;
/* Loop over cols */
do i=1 to dim(Cols);
if missing(Cols(i)) then Cols(i) = Mean;
end;
end;
run;
or something similar ...
... View more
