topic Re: proc corr in Statistical Procedures

proc corr

mt88 — Tue, 18 Aug 2020 17:45:13 GMT

Hello,

I am using proc corr with the nomiss option to calculate Cronbach's alpha:

proc corr data = datasetname nomiss alpha;

I am getting this error:

ERROR: The NOMISS option is specified, but all variables have at least one missing value
for all observations in the input data set.

I'm new to this statistic so I'm not sure how to resolve this issue. Any information would be appreciated.

Thank you, Matt

Re: proc corr

WarrenKuhfeld — Tue, 18 Aug 2020 17:57:55 GMT

You might start by printing the data set. Is this really the kind of data set that you want to use with nomiss? Obviously not, but look at the data and convince yourself. Then either don't specify the option or get a different data set that is more complete or use fewer variables.

Re: proc corr

mkeintz — Tue, 18 Aug 2020 17:59:28 GMT

First, it would be good to see the actual code that produced this error message.

But in short, let's say you have 10 variables. The NOMISS options tells SAS to throw away any observations in which at least one of those variables is missing. So, theoretically if each of the 10 variables was missing only(!!) 10% of the time, it's possible that each observation would have a single missing value, and would therefore be discarded, leaving no observations to submit to the proc corr.

Re: proc corr

ballardw — Tue, 18 Aug 2020 19:51:36 GMT

Show your entire proc corr code.

If you are interested in specific variables you may need/want fewer variables on a VAR and/or WITH statement.

From the documentation NOMISS

Excludes observations with missing analysis values from the analysis

So you have told the procedure to use records that have, without more code shown, to use all numeric variables but only if none of them have missing values. Since the error message says every record has at least one missing variable all the records are excluded.

If you are interested in just some variables the use a VAR statement to list them. The WITH statement would do correlations between the varaibles on a VAR statement and those on a WITH statement only.