topic Re: Syntax to change missing values in SAS Programming

Syntax to change missing values

ksaser — Tue, 02 Feb 2016 00:18:19 GMT

I am looking for syntax to change the missing values of a variable to the average of the remaining values of the same variable

for example:

for the variable duration-

duration : 10 20 30 40 . . . ( . meaning missing values )

I want to replace the three missing values with the average of 10 20 30 40. I want to repliate this over a variable having more than 1000 values.

Can anyone help me out ?

Many Thanks!

Ksharp — Tue, 02 Feb 2016 01:20:42 GMT

data have;
input duration;
cards;
10 
20 
30 
40 
. 
. 
. 
;
run;

proc stdize data=have missing=mean reponly out=want;
var _numeric_;
run;

RW9 — Tue, 02 Feb 2016 10:08:03 GMT

As an option, you could also do:

proc sql;
  create table WANT as
  select  coalesce(DURATION,(select mean(DURATION) from HAVE)) as DURATION
  from    HAVE;
quit;

ChrisNZ — Thu, 25 Feb 2016 09:08:05 GMT

Not having a nested clause speeds things up a bit.

create table WANT as
select coalesce(DURATION, mean(DURATION) ) as DURATION
from HAVE;