Date: Fri, 8 Oct 1999 15:38:28 -0600
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Replacing Missing values with the Mean
Content-type: text/plain; charset=US-ASCII
I haven't had any luck finding a solution to this in the manuals.
Hopefully someone can help.
Using SAS 6.12 on Win95, I need to run several PROC CORR
ALPHA on a dataset with several missing values spread throughout
it. According to the SAS Log, it's recommended to use NOMISS
when calculating ALPHA. This is fine, except it leaves us with a
low n. We would like to replace each missing value with the mean
of that variable. Is there an option within PROC CORR or another
PROC to do this automatically or will I have to calculate the means
beforehand and run a data step to replace the missing values. I
have around 40 odd variables so I'd rather do the former than the
Thanks a lot for any assistance,
Program Analyst, Sr.
Applied Gerontology Program
University of Alabama