Date:         Mon, 5 Mar 2001 17:48:16 -0000
Reply-To:     Nigel.Pain@SCOTLAND.GSI.GOV.UK
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nigel Pain <Nigel.Pain@SCOTLAND.GSI.GOV.UK>
Subject:      Re: SAS Time Syntax
Comments: To: nat_blue@YAHOO.COM
Content-Type: text/plain; charset="iso-8859-1"

Use a where with time constants:

WHERE '08:30'T <= ttrans <= '13:30'T;

No need for SQL unless you want to (said the SQL-illiterate!).

***************************************************
Nigel Pain
Scottish Executive Development Department
Business Support Unit
Victoria Quay
EDINBURGH
EH6 6QQ
UK
Tel +44 131 244 7237
Fax +44 131 244 7281
Mailto:nigel.pain@scotland.gsi.gov.uk
Website: http:\www.scotland.gov.uk


> -----Original Message-----
> From: Nat [mailto:nat_blue@YAHOO.COM]
> Sent: 05 March 2001 17:02
> Subject: SAS Time Syntax
>
>
> If my dataset has a column name "TTRANS" which is in hhmmss
> format. Could
> you please tell me how can I select only transactions
> (records) that TTRANS
> between 8.30 AM  and 1.30 PM ?
> Should I use proc SQL? And how is the syntax ?
>
> Thanks,
> Nat
>