Date:         Tue, 19 Apr 2005 13:49:42 -0400
Reply-To:     "Rao, Julie (Institutional Research)" <jrao@monroecc.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Rao, Julie (Institutional Research)" <jrao@monroecc.edu>
Subject:      Re: select time
Comments: To: Pansy Peng <fenghua@PANAM.EDU>
Content-Type: text/plain; charset="us-ascii"

Not tremendously elegant, but the following untested syntax should work.
You are creating a separate variable for ampm indicator and the actual
start time in hours & minutes.

STRING start (A4).
STRING ampm (A2).

COMPUTE start = SUBSTR(start_time, 1, 4).
COMPUTE ampm = SUBSTR(start_time, 5, 2).

SELECT IF ampm EQ 'PM' AND start GE '0430'.

HTH.

Julie

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Pansy Peng
Sent: Tuesday, April 19, 2005 12:53 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: select time

Hi,

I have a file in SPSS like this:

Course           start_time
EDU2306          0430PM
ACC4589          0730AM
FIN3490          1210PM
MAT8731          0700PM

Could you tell me how I can select courses only start after 4:30pm.
Thank you so much.

Fenghua