Date Time Subset

[gstover]

I am trying to figure out the syntax to subset a dataset based on the date and time.  First to grab all records that are prior to 12:01 a.m.  Then within these records query another date variable for the date and time between 12:01 am and 4:00 am.

[Reeza]

Assuming you have SAS dates/times and your variables are times it's fairly straightforward:

where timeVariable < '00:01:00't and  timepart(secondDateTimeVariable) between '00:01:00't and '04:00;00't;

Key concepts:

• Use TIMEPART() to get the time portion of a datetime variable
• Specify time as 'HH:MM:SS't
• FYI - If you use a WHERE statement you can use BETWEEN. If you use an IF statement, then you cannot use BETWEEN and need to structure that condition more similar to the first condition.

---

@gstover wrote:

I am trying to figure out the syntax to subset a dataset based on the date and time.  First to grab all records that are prior to 12:01 a.m.  Then within these records query another date variable for the date and time between 12:01 am and 4:00 am.

---