Choose a time range from a date time

[KristianDagless]

Hi All,

I have a data set and I need to filter based on a specific time from a datetime variable.

For example:

'11MAR2019:13:02:30 '

I'd like to filter on all results post 5PM on the above variable, I'm new to SAS. I understand a timepart may be suitable here but I am unable to produce the results I require using this function. 

Many thanks in advance for your assistance.

[Kurt_Bremser]

Please show your code and log, and some example data (in usable form - a data step with datalines), so we have material for diagnosis.

Your mention of the timepart() function is correct, though:

data have;
input dtval e8601dt19.;
format dtval e8601dt19.;
cards;
2019-03-20T08:00:00
2019-03-20T17:05:00
;
run;

data want;
set have;
where timepart(dtval) > '17:00:00't;
run;

proc print data=want noobs;
run;

Result:

dtval

2019-03-20T17:05:00

Only the later of the two observations is selected.

[ballardw]

Or use one of the time extraction functions:

data want;
   set have;
   where hour(dtval) ge 17;
run; 

for example. I wasn't sure if you wanted strictly greater than or greater than or equal so used the later.