Help using Base SAS procedures

select range of time

Reply
Regular Contributor
Posts: 240

select range of time

I have these fields in my table.The time_start runs from 01:00 thru 23:00
ID
DATE START
TIME_START

I need to select a time range between 8:00 AM thru 17:00 only how do I exclude the time that falls from this range?
Thanks For Your Assistance
Super User
Posts: 10,018

Re: select range of time

Hi.
How about :


[pre]
data x;
input time time5.;
format time time5.;
cards;
08:09
10:21
12:00
23:22
;run;
data _x;
set x;
where time between '10:11't and '14:20't;
run;
[/pre]



Ksharp
Ask a Question
Discussion stats
  • 1 reply
  • 158 views
  • 0 likes
  • 2 in conversation