Date Time Subset

gstover — Tue, 23 Nov 2021 20:33:49 GMT

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.

Re: Date Time Subset

Reeza — Tue, 23 Nov 2021 21:13:17 GMT

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.

topic Re: Date Time Subset in SAS Programming

Date Time Subset

Re: Date Time Subset