SPSS warning from regression

classic Classic list List threaded Threaded
15 messages Options
Reply | Threaded
Open this post in threaded view
|

SPSS warning from regression

Yifan Lu-3
Dear list,

 

I am running multiple regression, but SPSS keeps telling me:

           

Warnings

 

There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.

 

I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!

 

Regards,

 

Yifan Lu

 

 
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Richard Ristow
At 05:50 PM 3/5/2007, Yifan Lu wrote:

>I am running multiple regression, but SPSS keeps telling me:
>
>>Warnings
>>There are no valid cases for models with dependent variable alldays.
>>Statistics cannot be computed.
>>No valid cases found. Equation-building skipped.
>
>Anybody also had such problem before? Any suggestions to fix the
>problem? Thank you!

The default (and recommended) practice for regression is 'listwise
deletion': a case is excluded if any of the dependent or independent
variables is missing. The problem you describe can arise when you lose
all data because each case has some variable missing.

>I checked the data and it seems all right. I also ran descriptives and
>the results come out right.

Descriptives won't tell you enough; they give the statistics on single
variables, not on all of them together.

Look at your variables, especially for
. Any that are missing for a large proportion of the cases
. Any that may be mutually exclusive - if one is present, the other
will be missing

In principle, you could get your problem from plain bad luck: you don't
have much missing data, but by chance every case has some missing
variable. (In this case, missing value imputation may be warranted.)

More commonly, though, there's something in the structure of your data
that ensures you don't have complete data for any case. Look for that
first.

-Good luck,
  Richard Ristow
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Beadle, ViAnn
In reply to this post by Yifan Lu-3
When you ran descriptive, did you include all the variables used in regression? If so, what is the listwise N shown in the descriptives output? If any variable used in the regression has a missing value, that case is excluded from the analysis.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Yifan Lu
Sent: Monday, March 05, 2007 4:50 PM
To: [hidden email]
Subject: SPSS warning from regression

Dear list,



I am running multiple regression, but SPSS keeps telling me:



Warnings



There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.



I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!



Regards,



Yifan Lu
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Nivruti Hinge
In reply to this post by Yifan Lu-3
One of the dependent variable must be having many missing values so please
check for the missing values in the dependent variable list.

-Regards,
Nivruti Hinge
Senior Member Of Technical  Staff
Persistent Systems Pvt. Ltd.
http://www.persistentsys.com
Direct : +91 (20) 30235627

____________________________________________________________________________
_______________
Persistent Systems - Software Development Partner for Competitive Advantage.
Persistent Systems provides custom software product development services.
With over 15 years, 140 customers, and 700 release cycles experience, we
deliver unmatched value of higher quality, faster time to market and lower
total costs.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Yifan Lu
Sent: Tuesday, March 06, 2007 4:20 AM
To: [hidden email]
Subject: SPSS warning from regression

Dear list,



I am running multiple regression, but SPSS keeps telling me:



Warnings



There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.



I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!



Regards,



Yifan Lu






DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails.
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Ornelas, Fermin
In reply to this post by Yifan Lu-3
This is telling you that for some reason SPSS is not finding the
dependent variable. Therefore it reports it to you as missing and does
nothing on the regression equation.

I actually find frustrating trying to learn SPSS.

Fermin Ornelas, Ph.D.
Management Analyst III, AZ DES
Tel: (602) 542-5639
E-mail: [hidden email]

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Nivruti Hinge
Sent: Monday, March 05, 2007 9:40 PM
To: [hidden email]
Subject: Re: SPSS warning from regression

One of the dependent variable must be having many missing values so
please
check for the missing values in the dependent variable list.

-Regards,
Nivruti Hinge
Senior Member Of Technical  Staff
Persistent Systems Pvt. Ltd.
http://www.persistentsys.com
Direct : +91 (20) 30235627

________________________________________________________________________
____
_______________
Persistent Systems - Software Development Partner for Competitive
Advantage.
Persistent Systems provides custom software product development
services.
With over 15 years, 140 customers, and 700 release cycles experience, we
deliver unmatched value of higher quality, faster time to market and
lower
total costs.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Yifan Lu
Sent: Tuesday, March 06, 2007 4:20 AM
To: [hidden email]
Subject: SPSS warning from regression

Dear list,



I am running multiple regression, but SPSS keeps telling me:



Warnings



There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.



I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!



Regards,



Yifan Lu






DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is
the property of Persistent Systems Pvt. Ltd. It is intended only for the
use of the individual or entity to which it is addressed. If you are not
the intended recipient, you are not authorized to read, retain, copy,
print, distribute or use this message. If you have received this
communication in error, please notify the sender and delete all copies
of this message. Persistent Systems Pvt. Ltd. does not accept any
liability for virus infected mails.

NOTICE: This e-mail (and any attachments) may contain PRIVILEGED OR
CONFIDENTIAL information and is intended only for the use of the
specific individual(s) to whom it is addressed.  It may contain
information that is privileged and confidential under state and federal
law.  This information may be used or disclosed only in accordance with
law, and you may be subject to penalties under law for improper use or
further disclosure of the information in this e-mail and its
attachments. If you have received this e-mail in error, please
immediately notify the person named above by reply e-mail, and then
delete the original e-mail.  Thank you.
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Hector Maletta
        This is not exactly a case of "not finding the dependent variable"
or "one of the dependent variables having missing values". The problem is
that any case for which at least one variable in the equation (dependent or
independent) has a missing value is excluded from the analysis. If all the
cases have a missing value for at least one of the relevant variables, then
all cases were be excluded and there would be no cases left for the
analysis; in such a situation SPSS reports there are no valid cases found
and no equation can be built.
        Facing such plight, you should analyze the pattern of missing
values. If it is mainly the responsibility of one specific variable,
excluding that variable from the analysis may be enough to leave you with
enough cases, though perhaps that variable may be essential to your
theoretical pursuit. Another approach is imputation of values (e.g. using
regression, as in the SPSS Missing Values module) in order to have valid
(albeit not really observed) values for all variables and cases, though this
approach may be disputable if applied indiscriminately. One should also
analyze whether the missing values are distributed randomly or following
some pattern.

        Hector

        -----Mensaje original-----
De: SPSSX(r) Discussion [mailto:[hidden email]] En nombre de
Ornelas, Fermin
Enviado el: 06 March 2007 16:08
Para: [hidden email]
Asunto: Re: SPSS warning from regression

        This is telling you that for some reason SPSS is not finding the
        dependent variable. Therefore it reports it to you as missing and
does
        nothing on the regression equation.

        I actually find frustrating trying to learn SPSS.

        Fermin Ornelas, Ph.D.
        Management Analyst III, AZ DES
        Tel: (602) 542-5639
        E-mail: [hidden email]

        -----Original Message-----
        From: SPSSX(r) Discussion [mailto:[hidden email]] On
Behalf Of
        Nivruti Hinge
        Sent: Monday, March 05, 2007 9:40 PM
        To: [hidden email]
        Subject: Re: SPSS warning from regression

        One of the dependent variable must be having many missing values so
        please
        check for the missing values in the dependent variable list.

        -Regards,
        Nivruti Hinge
        Senior Member Of Technical  Staff
        Persistent Systems Pvt. Ltd.
        http://www.persistentsys.com
        Direct : +91 (20) 30235627


________________________________________________________________________
        ____
        _______________
        Persistent Systems - Software Development Partner for Competitive
        Advantage.
        Persistent Systems provides custom software product development
        services.
        With over 15 years, 140 customers, and 700 release cycles
experience, we
        deliver unmatched value of higher quality, faster time to market and
        lowe
        total costs.

        -----Original Message-----
        From: SPSSX(r) Discussion [mailto:[hidden email]] On
Behalf Of
        Yifan Lu
        Sent: Tuesday, March 06, 2007 4:20 AM
        To: [hidden email]
        Subject: SPSS warning from regression

        Dear list,



        I am running multiple regression, but SPSS keeps telling me:



        Warnings



        There are no valid cases for models with dependent variable alldays.
        Statistics cannot be computed.

        No valid cases found. Equation-building skipped.



        I checked the data and it seems all right. I also ran descriptives
and
        the results come out right. Anybody also had such problem before?
Any
        suggestions to fix the problem? Thank you!



        Regards,



        Yifan Lu






        DISCLAIMER
        ==========
        This e-mail may contain privileged and confidential information
which is
        the property of Persistent Systems Pvt. Ltd. It is intended only for
the
        use of the individual or entity to which it is addressed. If you are
not
        the intended recipient, you are not authorized to read, retain,
copy,
        print, distribute or use this message. If you have received this
        communication in error, please notify the sender and delete all
copies
        of this message. Persistent Systems Pvt. Ltd. does not accept any
        liability for virus infected mails.

        NOTICE: This e-mail (and any attachments) may contain PRIVILEGED OR
        CONFIDENTIAL information and is intended only for the use of the
        specific individual(s) to whom it is addressed.  It may contain
        information that is privileged and confidential under state and
federal
        law.  This information may be used or disclosed only in accordance
with
        law, and you may be subject to penalties under law for improper use
or
        further disclosure of the information in this e-mail and its
        attachments. If you have received this e-mail in error, please
        immediately notify the person named above by reply e-mail, and then
        delete the original e-mail.  Thank you.
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Ornelas, Fermin
In reply to this post by Yifan Lu-3
In theory when building a statistical model, prior to undertaking the
actual estimation one must carry out some exploratory analysis to ensure
the integrity of the data. That is things like what percentage of values
for each variable are missing, what are the range values for the
predictors, are the values consistent with a priori considerations
derived either from personal experience or past research studies. Some
correlation analysis between the response variable and the predictors
could give a hint on what to expect from the final estimation.

Once one is satisfied and verified some of the exploratory analysis then
it is time to do the actual estimation. Doing those preliminary steps
will limit the possibility of getting non sense results. Furthermore,
once the final model is obtained one must verify that certain model
assumptions are met such as normality, constant variance, independence,
an outliers. If the model passes those filters then one still has to
consider things such as parameter significance, signs expectations for
the parameter estimates, R^2, etc.


Fermin Ornelas, Ph.D.
Management Analyst III, AZ DES
Tel: (602) 542-5639
E-mail: [hidden email]

-----Original Message-----
From: Hector Maletta [mailto:[hidden email]]
Sent: Tuesday, March 06, 2007 8:19 AM
To: Ornelas, Fermin; [hidden email]
Subject: RE: SPSS warning from regression

        This is not exactly a case of "not finding the dependent
variable"
or "one of the dependent variables having missing values". The problem
is
that any case for which at least one variable in the equation (dependent
or
independent) has a missing value is excluded from the analysis. If all
the
cases have a missing value for at least one of the relevant variables,
then
all cases were be excluded and there would be no cases left for the
analysis; in such a situation SPSS reports there are no valid cases
found
and no equation can be built.
        Facing such plight, you should analyze the pattern of missing
values. If it is mainly the responsibility of one specific variable,
excluding that variable from the analysis may be enough to leave you
with
enough cases, though perhaps that variable may be essential to your
theoretical pursuit. Another approach is imputation of values (e.g.
using
regression, as in the SPSS Missing Values module) in order to have valid
(albeit not really observed) values for all variables and cases, though
this
approach may be disputable if applied indiscriminately. One should also
analyze whether the missing values are distributed randomly or following
some pattern.

        Hector

        -----Mensaje original-----
De: SPSSX(r) Discussion [mailto:[hidden email]] En nombre de
Ornelas, Fermin
Enviado el: 06 March 2007 16:08
Para: [hidden email]
Asunto: Re: SPSS warning from regression

        This is telling you that for some reason SPSS is not finding the
        dependent variable. Therefore it reports it to you as missing
and
does
        nothing on the regression equation.

        I actually find frustrating trying to learn SPSS.

        Fermin Ornelas, Ph.D.
        Management Analyst III, AZ DES
        Tel: (602) 542-5639
        E-mail: [hidden email]

        -----Original Message-----
        From: SPSSX(r) Discussion [mailto:[hidden email]] On
Behalf Of
        Nivruti Hinge
        Sent: Monday, March 05, 2007 9:40 PM
        To: [hidden email]
        Subject: Re: SPSS warning from regression

        One of the dependent variable must be having many missing values
so
        please
        check for the missing values in the dependent variable list.

        -Regards,
        Nivruti Hinge
        Senior Member Of Technical  Staff
        Persistent Systems Pvt. Ltd.
        http://www.persistentsys.com
        Direct : +91 (20) 30235627


________________________________________________________________________
        ____
        _______________
        Persistent Systems - Software Development Partner for
Competitive
        Advantage.
        Persistent Systems provides custom software product development
        services.
        With over 15 years, 140 customers, and 700 release cycles
experience, we
        deliver unmatched value of higher quality, faster time to market
and
        lowe
        total costs.

        -----Original Message-----
        From: SPSSX(r) Discussion [mailto:[hidden email]] On
Behalf Of
        Yifan Lu
        Sent: Tuesday, March 06, 2007 4:20 AM
        To: [hidden email]
        Subject: SPSS warning from regression

        Dear list,



        I am running multiple regression, but SPSS keeps telling me:



        Warnings



        There are no valid cases for models with dependent variable
alldays.
        Statistics cannot be computed.

        No valid cases found. Equation-building skipped.



        I checked the data and it seems all right. I also ran
descriptives
and
        the results come out right. Anybody also had such problem
before?
Any
        suggestions to fix the problem? Thank you!



        Regards,



        Yifan Lu






        DISCLAIMER
        ==========
        This e-mail may contain privileged and confidential information
which is
        the property of Persistent Systems Pvt. Ltd. It is intended only
for
the
        use of the individual or entity to which it is addressed. If you
are
not
        the intended recipient, you are not authorized to read, retain,
copy,
        print, distribute or use this message. If you have received this
        communication in error, please notify the sender and delete all
copies
        of this message. Persistent Systems Pvt. Ltd. does not accept
any
        liability for virus infected mails.

        NOTICE: This e-mail (and any attachments) may contain PRIVILEGED
OR
        CONFIDENTIAL information and is intended only for the use of the
        specific individual(s) to whom it is addressed.  It may contain
        information that is privileged and confidential under state and
federal
        law.  This information may be used or disclosed only in
accordance
with
        law, and you may be subject to penalties under law for improper
use
or
        further disclosure of the information in this e-mail and its
        attachments. If you have received this e-mail in error, please
        immediately notify the person named above by reply e-mail, and
then
        delete the original e-mail.  Thank you.
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Björn Türoque
In reply to this post by Yifan Lu-3
 Dude, the quickest way to figure out what is going on is to load all the
variables you want to look at into a bivariate correlation. Under Analyze
--> Correlate --> Bivariate. If you see a box full of periods, your
regression won't work, the box full of periods means that one question
was answered by only part of the respondents and the other question
was answered by a different part of the respondents. This usually happens if
there is a skip pattern in your data or if the same questions are not
answered by everyone in the survey.

Multiple regression needs a certain number of cases that have values in all
the variables you load into the equation. These guys are right in that you
need to understand how your data is structured before running this analysis,
it helps to run prior analysis just to see if there are relationships
between all of your independent variables and your dependent variables
before doing a regression.

Don



On 3/5/07, Yifan Lu <[hidden email]> wrote:

>
> Dear list,
>
>
>
> I am running multiple regression, but SPSS keeps telling me:
>
>
>
> Warnings
>
>
>
> There are no valid cases for models with dependent variable alldays.
> Statistics cannot be computed.
>
> No valid cases found. Equation-building skipped.
>
>
>
> I checked the data and it seems all right. I also ran descriptives and
> the results come out right. Anybody also had such problem before? Any
> suggestions to fix the problem? Thank you!
>
>
>
> Regards,
>
>
>
> Yifan Lu
>
>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Yifan Lu-3
In reply to this post by Yifan Lu-3
Thank you all for responding to my question. I found out that I forgot
to exclude an independent variable that has all missing values. Now the
problem has been solved.

Regards,

Yifan

        -----Original Message-----
        From: SPSSX(r) Discussion [mailto:[hidden email]] On
Behalf Of
        Yifan Lu
        Sent: Tuesday, March 06, 2007 4:20 AM
        To: [hidden email]
        Subject: SPSS warning from regression

        Dear list,



        I am running multiple regression, but SPSS keeps telling me:



        Warnings



        There are no valid cases for models with dependent variable
alldays.
        Statistics cannot be computed.

        No valid cases found. Equation-building skipped.



        I checked the data and it seems all right. I also ran
descriptives
and
        the results come out right. Anybody also had such problem
before?
Any
        suggestions to fix the problem? Thank you!



        Regards,



        Yifan Lu
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Richard Ristow
In reply to this post by Björn Türoque
At 12:56 PM 3/8/2007, Don Asay wrote:

>Load all the variables you want to look at into a bivariate
>correlation. Under Analyze --> Correlate --> Bivariate. If you see a
>box full of periods, your
>regression won't work.

Actually, if you see ONE period your regression won't work. The period
(correlation missing) means that the two variables are valid in two or
fewer cases. The correlation is a normalized form of the covariance
needed for regression; so the covariance can't be computed either.

HOWEVER, you can see no periods at all, and it still won't work. With
listwise variable deletion (which you should use), only cases with all
variables present are available for the regression. You can see this
happen, if you run CORRELATIONS with listwise deletion. Like this (SPSS
15 draft output; WRR-not saved separately):

List
|-----------------------------|---------------------------|
|Output Created               |08-MAR-2007 16:45:08       |
|-----------------------------|---------------------------|
CASENUM DEPEND  IND1  IND2  IND3

     1       .9    .    9.8   7.9
     2      7.9   4.4    .    6.8
     3      3.7   5.5   1.4    .
     4      5.7    .    5.6   7.4
     5      9.0   3.3    .    8.0
     6      1.8   8.7   8.2    .
     7      9.5    .    2.7   8.9
     8      6.3   6.0    .    5.4
     9      5.6   5.2   3.8    .

Number of cases read:  9    Number of cases listed:  9


CORRELATIONS
   /VARIABLES=DEPEND IND1 IND2 IND3
   /PRINT=TWOTAIL NOSIG
   /MISSING=PAIRWISE .


Correlations
|-----------------------------|---------------------------|
|Output Created               |08-MAR-2007 16:45:08       |
|-----------------------------|---------------------------|
Correlations
|------|---------------|--------|--------|-----|-----|
|      |               |DEPEND  |IND1    |IND2 |IND3 |
|------|---------------|--------|--------|-----|-----|
|DEPEND|Pearson        |1       |-.900(*)|-.689|.135 |
|      |Correlation    |        |        |     |     |
|      |---------------|--------|--------|-----|-----|
|      |Sig. (2-tailed)|        |.015    |.130 |.799 |
|      |N              |9       |6       |6    |6    |
|------|---------------|--------|--------|-----|-----|
|IND1  |Pearson        |-.900(*)|1       |.903 |-.993|
|      |Correlation    |        |        |     |     |
|      |---------------|--------|--------|-----|-----|
|      |Sig. (2-tailed)|.015    |        |.283 |.073 |
|      |N              |6       |6       |3    |3    |
|------|---------------|--------|--------|-----|-----|
|IND2  |Pearson        |-.689   |.903    |1    |-.563|
|      |Correlation    |        |        |     |     |
|      |---------------|--------|--------|-----|-----|
|      |Sig. (2-tailed)|.130    |.283    |     |.619 |
|      |N              |6       |3       |6    |3    |
|------|---------------|--------|--------|-----|-----|
|IND3  |Pearson        |.135    |-.993   |-.563|1    |
|      |Correlation    |        |        |     |     |
|      |---------------|--------|--------|-----|-----|
|      |Sig. (2-tailed)|.799    |.073    |.619 |     |
|      |---------------|--------|--------|-----|-----|
|      |N              |6       |3       |3    |6    |
|------|---------------|--------|--------|-----|-----|
* Correlation is significant at the 0.05 level (2-tailed).


CORRELATIONS
   /VARIABLES=DEPEND IND1 IND2 IND3
   /PRINT=TWOTAIL NOSIG
   /MISSING=LISTWISE .


Correlations
|-----------------------------|---------------------------|
|Output Created               |08-MAR-2007 16:45:08       |
|-----------------------------|---------------------------|
Correlations(b)
|------|---------------|------|----|----|----|
|      |               |DEPEND|IND1|IND2|IND3|
|------|---------------|------|----|----|----|
|DEPEND|Pearson        |.(a)  |.(a)|.(a)|.(a)|
|      |Correlation    |      |    |    |    |
|      |---------------|------|----|----|----|
|      |Sig. (2-tailed)|      |.   |.   |.   |
|------|---------------|------|----|----|----|
|IND1  |Pearson        |.(a)  |.(a)|.(a)|.(a)|
|      |Correlation    |      |    |    |    |
|      |---------------|------|----|----|----|
|      |Sig. (2-tailed)|.     |    |.   |.   |
|------|---------------|------|----|----|----|
|IND2  |Pearson        |.(a)  |.(a)|.(a)|.(a)|
|      |Correlation    |      |    |    |    |
|      |---------------|------|----|----|----|
|      |Sig. (2-tailed)|.     |.   |    |.   |
|------|---------------|------|----|----|----|
|IND3  |Pearson        |.(a)  |.(a)|.(a)|.(a)|
|      |Correlation    |      |    |    |    |
|      |---------------|------|----|----|----|
|      |Sig. (2-tailed)|.     |.   |.   |    |
|------|---------------|------|----|----|----|
a Cannot be computed because at least one of the variables is constant.
b Listwise N=0


REGRESSION
   /MISSING LISTWISE
   /STATISTICS COEFF OUTS R ANOVA
   /CRITERIA=PIN(.05) POUT(.10)
   /NOORIGIN
   /DEPENDENT DEPEND
   /METHOD=ENTER IND1 IND2 IND3  .


Regression
|-----------------------------|---------------------------|
|Output Created               |08-MAR-2007 16:46:39       |
|-----------------------------|---------------------------|
Warnings
|--------------------------------------------------------|
|There are no valid cases for models with dependent      |
|variable DEPEND.                                        |
|Statistics cannot be computed.                          |
|--------------------------------------------------------|
|No valid cases found.                                   |
|Equation-building skipped.                              |
|--------------------------------------------------------|


===================
APPENDIX: Test data
===================
NEW FILE.
INPUT PROGRAM.
.  NUMERIC CASENUM      (F3).

.  NUMERIC DEPEND       (F5.1).
.  NUMERIC IND1 TO IND3 (F5.1).
.  LOOP CASENUM = 1 TO 9.
.     VECTOR DATA_VAR=DEPEND TO IND3.
.     LOOP #VNUM = 1 TO 4.
.        COMPUTE DATA_VAR(#VNUM) = RV.UNIFORM(0,10).
.        COMPUTE #ZAP = 2 + MOD((CASENUM-1),3).
.        COMPUTE DATA_VAR(#ZAP)  = $SYSMIS.
.     END LOOP.
       END CASE.
.  END LOOP.
END FILE.
END INPUT PROGRAM.

LIST.
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Avneer
In reply to this post by Yifan Lu-3
Although this reply is slightly late, it may help others that are also facing
the same issue now.

If you are doing a multiple regression, with multiple variables, you may
have made a rooky erorr of not first calculating the mean and total for the
varibles.

You do this by ,

going to transform, then compute variable, then for the label type
meaninsertvariablename then in the box put MEAN (Q___ to Q___) this will
then create a coloum for this.

to get the total again , transform, compute variable, then label total.....
then in the box put (Q___ +Q____... etc)  this will create a total.

then to calcualte the multiple reggresion , go to analyse, regression,
linear.
in the dv  enter the mean dv variable you are mesuring e.g. meanHappiness
in the Iv enter the other variables e.g. meanaggression, meanenvironment
etc.

you can then tap the stat's box and select the correct measures you want ,
e.g. part and partial correlantions, estimates, model fit, colineraity.

then press continue then ok

this will then output your results, i hope this helps anyone who comes
across this issue.





--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Art Kendall
In reply to this post by Richard Ristow
The purpose of statistics is to make reasoned statements about some
phenomenon.  Understanding why data is missing is crucial in the reasoning
behind statements the data is used to support.

Before any analysis is done you should be sure that no $sysmis values exist
in your data.  A major advantage of SPSS over other packages is the
distinction between system-missing and user missing.

System-missing in the data means the user has given instructions that the
system cannot obey.  This means either
(a) that on input a value cannot be read according to instructions
   OR
(b) a transformation cannot be done as instructed, e.g., division by zero,
or square root of a negative number.

System-missing in the results means that some computations in the procedure
cannot be done as iinstructed.  These can happen because of user missing
values.  

Any $sysmis value means that a user should check on how well (s)he gave
instructions.
some examples of user missing values might be
      0 'Possibly ambiguous zero'
    -1 'Missing unknown reason'
    -2 'Missing  all HH this Place & Phase'
    -3 'Entry or coding error'
    -4 'no people this HH this phase'
    -5 'Not a dwelling'
    -6 'All zero all HH this Place & Phase'
    -10 'Legit filter skip, does not apply'
    -11 'Mult Response: missing not first response'
    -12 ‘Mult Response: no mentions at all’
   -13 ‘None’
   -14 ’Do not know’
   -15 ‘not computable’
  - 999 'invalid longitude or Latitude'
   99 'misprinted data gathering instrument'
   98 'more than 1 answer'
   97 'interviwer mistake'
  -1 'no pregnamcies because male'
  -2 'no prgnacies over 55'
  -3 'no pregnacies because under 12'
  -4 'refused to answer




-----
Art Kendall
Social Research Consultants
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Art Kendall
Social Research Consultants
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Art Kendall
In reply to this post by Richard Ristow
The purpose of statistics is to make reasoned statements about some
phenomenon.  Understanding why data is missing is crucial in the reasoning
behind statements the data is used to support.

Before any analysis is done you should be sure that no $sysmis values exist
in your data.  A major advantage of SPSS over other packages is the
distinction between system-missing and user missing.

System-missing in the data means the user has given instructions that the
system cannot obey.  This means either
(a) that on input a value cannot be read according to instructions
   OR
(b) a transformation cannot be done as instructed, e.g., division by zero,
or square root of a negative number.

System-missing in the results means that some computations in the procedure
cannot be done as iinstructed.  These can happen because of user missing
values.  

Any $sysmis value means that a user should check on how well (s)he gave
instructions.
some examples of user missing values might be
      0 'Possibly ambiguous zero'
    -1 'Missing unknown reason'
    -2 'Missing  all HH this Place & Phase'
    -3 'Entry or coding error'
    -4 'no people this HH this phase'
    -5 'Not a dwelling'
    -6 'All zero all HH this Place & Phase'
    -10 'Legit filter skip, does not apply'
    -11 'Mult Response: missing not first response'
    -12 ‘Mult Response: no mentions at all’
   -13 ‘None’
   -14 ’Do not know’
   -15 ‘not computable’
  - 999 'invalid longitude or Latitude'
   99 'misprinted data gathering instrument'
   98 'more than 1 answer'
   97 'interviewer mistake'
  -1 'no pregnancies because male'
  -2 'no pregnancies over 55'
  -3 'no pregnancies because under 12'
  -4 'refused to answer




-----
Art Kendall
Social Research Consultants
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Art Kendall
Social Research Consultants
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Jon Peck
In reply to this post by Avneer
The original post, which did not appear in my email, seems to be this.
Warnings

There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.

I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!
-----------
This probably means that there was enough missing data to knock out  all the cases.
A  case would be excluded if any of the variables in the regression has a missing value.

This has nothing to do with "calculating the mean and total for the variables" except that that calculation
from REGRESION would give you the same error message.

On Tue, Nov 3, 2020 at 10:24 PM Avneer <[hidden email]> wrote:
Although this reply is slightly late, it may help others that are also facing
the same issue now.

If you are doing a multiple regression, with multiple variables, you may
have made a rooky erorr of not first calculating the mean and total for the
varibles.

You do this by ,

going to transform, then compute variable, then for the label type
meaninsertvariablename then in the box put MEAN (Q___ to Q___) this will
then create a coloum for this.

to get the total again , transform, compute variable, then label total.....
then in the box put (Q___ +Q____... etc)  this will create a total.

then to calcualte the multiple reggresion , go to analyse, regression,
linear.
in the dv  enter the mean dv variable you are mesuring e.g. meanHappiness
in the Iv enter the other variables e.g. meanaggression, meanenvironment
etc.

you can then tap the stat's box and select the correct measures you want ,
e.g. part and partial correlantions, estimates, model fit, colineraity.

then press continue then ok

this will then output your results, i hope this helps anyone who comes
across this issue.





--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD


--
Jon K Peck
[hidden email]

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: SPSS warning from regression

Bruce Weaver
Administrator
Adding to Jon's summary, the OP posted this in March 2007:


> Thank you all for responding to my question. I found out that I forgot to
> exclude an independent variable that has all missing values. Now the
> problem has been solved.

Let me also reiterate some advice ViAnn gave earlier in the thread:  If one
includes all variables in the model on a DESCRIPTIVES command, the Valid N
(listwise) result at the bottom of the table will show how many observations
will be included in the regression model.  As Jon noted, there is no need to
compute a mean across variables.  

HTH.



Jon Peck wrote

> The original post, which did not appear in my email, seems to be this.
> Warnings
>
> There are no valid cases for models with dependent variable alldays.
> Statistics cannot be computed.
>
> No valid cases found. Equation-building skipped.
>
> I checked the data and it seems all right. I also ran descriptives and
> the results come out right. Anybody also had such problem before? Any
> suggestions to fix the problem? Thank you!
> -----------
> This probably means that there was enough missing data to knock out  all
> the cases.
> A  case would be excluded if any of the variables in the regression has a
> missing value.
>
> This has nothing to do with "calculating the mean and total for the
> variables" except that that calculation
> from REGRESION would give you the same error message.
>
> On Tue, Nov 3, 2020 at 10:24 PM Avneer &lt;

> avneers@

> &gt; wrote:
>
>> Although this reply is slightly late, it may help others that are also
>> facing
>> the same issue now.
>>
>> If you are doing a multiple regression, with multiple variables, you may
>> have made a rooky erorr of not first calculating the mean and total for
>> the
>> varibles.
>>
>> You do this by ,
>>
>> going to transform, then compute variable, then for the label type
>> meaninsertvariablename then in the box put MEAN (Q___ to Q___) this will
>> then create a coloum for this.
>>
>> to get the total again , transform, compute variable, then label
>> total.....
>> then in the box put (Q___ +Q____... etc)  this will create a total.
>>
>> then to calcualte the multiple reggresion , go to analyse, regression,
>> linear.
>> in the dv  enter the mean dv variable you are mesuring e.g. meanHappiness
>> in the Iv enter the other variables e.g. meanaggression, meanenvironment
>> etc.
>>
>> you can then tap the stat's box and select the correct measures you want
>> ,
>> e.g. part and partial correlantions, estimates, model fit, colineraity.
>>
>> then press continue then ok
>>
>> this will then output your results, i hope this helps anyone who comes
>> across this issue.
>>
>>
>>
>>
>>
>> --
>> Sent from: http://spssx-discussion.1045642.n5.nabble.com/
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>>

> LISTSERV@.UGA

>  (not to SPSSX-L), with no body text except the
>> command. To leave the list, send the command
>> SIGNOFF SPSSX-L
>> For a list of commands to manage subscriptions, send the command
>> INFO REFCARD
>>
>
>
> --
> Jon K Peck

> jkpeck@

>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

>  (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD





-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.