Date:         Mon, 7 Feb 2005 12:30:40 -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: declare missing for time data
Comments: To: Martin Sherman <MSherman@loyola.edu>
Content-Type: text/plain; charset="US-ASCII"

In reasonably recent versions of SPSS, you can use date constants on the MISSING VALUES command(also the VALUE LABELS command), e.g.,
MISSING VALUES bdate ( '02/10/1929' ).

They must be quoted and use the format of the variable being labeled.

In the user interface, you can do this via Data>Define Variable Properties.  Select the variable(s) of interest.  You will see a display of the values, and you can just check the missing values box for the ones you want.

If you have too old a version, you will have to figure out the actual number behind the time value and use that on the command.

Regards,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Martin Sherman
Sent: Monday, February 07, 2005 10:38 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: [SPSSX-L] declare missing for time data

Dear list, does anyone know how to declare time data as missing.
I have some invalid times in HH:MM format that I want to declare as
missing but have been able to figure out if it can be done.