topic Re: replace missing value with mean in SAS Programming

replace missing value with mean

supersonic — Thu, 22 Aug 2013 06:36:41 GMT

Hi I need to replace all missing values in a dataset with respective mean.

Find the sample i wrote.

%macro replace_missing(dataset);

proc means data=&dataset mean ; ;

output out=t (drop=_type_ _freq_) mean=/autoname;

run;

proc transpose data=t out=tr;

run;

data _null_;

set Tr end=last ;

call symput('mean'||left(_n_),col1);

if last then call symput('maxi', _n_);

/* x=left(_N_) */;

/* put _N_ maxi last x ; */;

run;

data &dataset;

set &dataset;

array num(*) _numeric_;

%do n=1 %to &maxi;

if num(&n)=. then num(&n)= &&mean&n;

%end;

run;

%mend;

%replace_missing(drop_missing);

run;

But this is not working..

Please help

Re: replace missing value with mean

BrunoMueller — Thu, 22 Aug 2013 07:27:55 GMT

supersonic

Proc STANDARD will do this for you, see code sample below.

data someTest;
  infile cards dlm=","; 
  input
    v1
    v2
  ;
cards; 
1,100
2,.
3,3
4,.
.,20
; 

proc standard data=someTest out=sometest2 replace print; 
run; 

proc print data=someTest;
run; 

proc print data=someTest2;
run; 

proc means data=someTest2;
  var v:;
run; 

Re: replace missing value with mean

Murray_Court — Thu, 22 Aug 2013 07:30:47 GMT

Works well with this dataset:

data one;

input thing;

datalines;

100

101

103

104

105

;

Can you give the log or the dataset you tried to use it with?

Re: replace missing value with mean

supersonic — Thu, 22 Aug 2013 07:45:08 GMT

Hi Murray

Its a very huge dataset.

My aim is to replace all the missing values with the corresponding mean value

Re: replace missing value with mean

LinusH — Thu, 22 Aug 2013 09:23:17 GMT

As stated by https://communities.sas.com/people/Murray_Court, attach a log or describe in more detail what it is that does not work...

Re: replace missing value with mean

jakarman — Thu, 22 Aug 2013 16:28:16 GMT

Base SAS(R) 9.4 Procedures Guide (PROC standard replacing missing by mean) == Bruno-s ==

The advantage of this procedure is it is part of SAS/Base Procs

If it should be more advanced like being in the Eminer processing, That one is using

SAS/STAT(R) 12.3 User's Guide (Proc MI) .

You nee to be licnesed for that.

Re: replace missing value with mean

sandyming — Fri, 23 Aug 2013 14:35:51 GMT

proc stdize data=old out=new missing=mean reponly;
var _numeric_;
run;

You can also calculate the median first, then read values from a second data set