Date:         Fri, 25 Mar 2005 13:25:08 -0600
Reply-To:     "Peck, Jon" <peck@spss.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Peck, Jon" <peck@spss.com>
Subject:      Re: Identify missing value definitions via script?
              (correction)
Comments: To: Dirk Enzmann <dirk.enzmann@jura.uni-hamburg.de>
Content-Type: text/plain; charset="us-ascii"

Missing value ranges are not valid for string variables (long or short).

LO and HIGH for numeric variables become the extreme possible floating point values, so you can test for numbers like these:

-1.79769313486232E+308
1.79769313486232E+308


You can, of course, also get this information from the DISPLAY VARIABLES command, and you can read it programmatically if you save the table 'Variable Information' using OMS.  In that case, you get the friendlier values "Lowest" and "Highest" in the missing values column.

As of SPSS 13, the DISPLAY command produces a pivot table.  In earlier version, it produced plain text.

Regards,
Jon Peck
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Dirk Enzmann
Sent: Friday, March 25, 2005 1:06 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: [SPSSX-L] Identify missing value definitions via script? (correction)

In the script example of my previous post, I forgot the IF statement!
The example should be:

' ---------------------------------- .

numVars = DataDoc.GetVariableInfo(VarNames, VarLabels, VarTypes,
VarLevels, LabelCounts)
numMiss = DataDoc.GetVariableMissingValues(MissingCounts, MissingValues)
MissVars = ""
For i = 0 To numVars-1
   If MissingCounts(i)-1 > -1 Then
     MissVars = MissVars & VarNames(i) & vbCrLf
   End If
Next
SyntaxDoc.Text = MissVars

' ---------------------------------- .

Dirk

*************************************************
Dr. Dirk Enzmann
Institute of Criminal Sciences
Dept. of Criminology
Schlueterstr. 28
D-20146 Hamburg
Germany

phone: +49-040-42838.7498 (office)
        +49-040-42838.4591 (Billon)
fax:   +49-040-42838.2344
email: dirk.enzmann@jura.uni-hamburg.de
www:
http://www2.jura.uni-hamburg.de/instkrim/kriminologie/Mitarbeiter/Enzmann/Enzmann.html
*************************************************