topic How to replace the missing values with the mean of the variable in SAS Studio

How to replace the missing values with the mean of the variable

murad130 — Sun, 01 Oct 2017 18:21:26 GMT

Hello,

I have a data set with several variables (X1, X2, X3,….) and I am trying to replace the missing values in the data set with the mean of the variable.

Here is my sample code:

DATA Complete_data;

Set mydata.original_data;

If X1= . Then X1 = mean(X1);

run;

Unfortunately, it’s not working. Please advise.

Thanks.

stat_sas — Sun, 01 Oct 2017 18:47:09 GMT

Hi,

Try this.

proc stdize data=mydata.original_data reponly method=mean out=Complete_data;

var X1 X2 X3;
run;

Reeza — Sun, 01 Oct 2017 21:21:18 GMT

The MEAN function in SAS works only on a row of data.

So the mean of a single variable is the same value, in this case missing.

If you wanted a data step approach you would need two passes, one to calculate the average and a second to merge it in with the data.

PROC STDIZE is easier to work with IMO.

murad130 — Mon, 02 Oct 2017 05:04:52 GMT

It worked!

Thank you so much for your help.

murad130 — Mon, 02 Oct 2017 05:06:44 GMT

Thank you very much for your help.