When I went to run a regression, I saw that only 2 cases were analyzed out of 187. When I made frequency tables of the variables, it said that 185 were missing. However, when I look at the data set there are no missing values. How can I fix this issue?

You must have missing values in the regression values. Remember that with the default listwise deletion of missing values, a case will be excluded from the regression if any variables in the regression specification (including those listed in a VARIABLES subcommand if you included one). And, of course, if you had a FILTER or SELECT IF command in effect for the REGRESSION command, cases might be excluded that way. If you check the Descriptives box on the Statistics subdialog, you can see the statistics for exactly the cases going into the regression.

Thank you for the prompt response. I do not have the FILTER or SELECT IF commands in effect. Also, this happens even if I have not run the regression analysis yet. For example, if I open up the data set and the first analysis I run is a frequency analysis, it still says that 185 cases are missing. I'm starting to think this is a dataset/software problem and am unsure how to resolve it.

If you want to send me the sav file and the variable specification, I'll take a look (jkpeckSupport Member)

Unfortunately I cannot send you the sav file - it has PHI information on it.

Can you send a screenshot of the Data Editor Variable View or, better, the output from the CODEBOOK procedure?

Support Member​  Is it the case that you have values specified in your data fields, but that these values have been defined as User Missing values? Check these fields in your Data Editor under the "Variable View". Are missing values defined?

Alternatively, when you say that you have no missing values, are you saying all of your fields are complete? The default way of dealing with missingness in REGRESSION is a LISTWISE deletion. So, within each row of your datatset, even a single missing value could mean the full record is dropped from the analysis.

I hope this helps!

Support Member​