topic Choose a time range from a date time in New SAS User

Choose a time range from a date time

KristianDagless — Thu, 21 Mar 2019 09:53:12 GMT

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.

Re: Choose a time range from a date time

Kurt_Bremser — Thu, 21 Mar 2019 10:05:53 GMT

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.

Re: Choose a time range from a date time

ballardw — Thu, 21 Mar 2019 14:31:36 GMT

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.