Date:         Thu, 10 Nov 2005 20:53:45 +0100
Reply-To:     Georg.Maubach@dpwnbc.net
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Georg Maubach <Georg.Maubach@dpwnbc.net>
Subject:      MISSING VALUES and EXECUTE question
Content-Type: text/plain; charset="us-ascii"

Hi All,

we wrote the following code:

Missing Value q12.01 to q12.05 q20.01 to q20.03 q03.01 q03.02 q05 q06
q46 ().
COMPUTE code = q12.01 * 7 - q12.02 * 0.3 + q12.03 * 1 - q12.04 * 3000 +
q12.05 * 2 +q20.01 * 12 - q20.02 * 0.4 + q20.03 * 9 + q03.01 - q03.02 +
q05 * q06 + q46 .
Missing Value q12.01 to q12.05 q20.01 to q20.03 q03.01 q03.02 q05 q06
q46 (-999 thru 0).
FREQUENCIES
  VARIABLES=code
  /ORDER=  ANALYSIS .

This code does not work. The result is that the new variable code has
system missings in all cases and the the statistical procedure
FREQUENCIES does not run cause the variable code has no cases.

If we include the EXECUTE command after the COMPUTE command the syntax
operates as expected.

MISSING VALUE q12.01 to q12.05 q20.01 to q20.03 q03.01 q03.02 q05 q06
q46 ().
COMPUTE code = q12.01 * 7 - q12.02 * 0.3 + q12.03 * 1 - q12.04 * 3000 +
q12.05 * 2 +q20.01 * 12 - q20.02 * 0.4 + q20.03 * 9 + q03.01 - q03.02 +
q05 * q06 + q46 .
EXECUTE.
MISSING VALUE q12.01 to q12.05 q20.01 to q20.03 q03.01 q03.02 q05 q06
q46 (-999 thru 0).
FREQUENCIES
  VARIABLES=code
  /ORDER=  ANALYSIS .

This time we found a solution but we would to understand why SPSS works
like that. What is the rule behind it? Can anybody help?

Best regards

Georg Maubach