topic Re: Filter by Date and Time in SAS Programming

Filter by Date and Time

ccaudillo100 — Tue, 12 Jul 2022 13:56:46 GMT

Hello,

Currently in a file the Created Date format is ddmmmyyyy:hh:mm:ss (ex 11JUL2022:23:49:55).

First we change the format to date9. and then we are deleting any incoming information using

Data Miles1;
Set Miles;
if CreatedDate1 >= (today()) then delete;

run;

What I would like to do is not change to date9 but instead leave it the way it is and then delete from a certain time on the current day.

Example

if CreatedDate1 >= (today at 01:00:00)

I am just not sure how to do that in sas since the file we are deleting form is a continually updating one with data coming in all day.

ballardw — Tue, 12 Jul 2022 14:07:48 GMT

You can create a datetime value from a date plus hour minute and seconds with the DHMS function.

DHMS(today(),12,0,0) for example creates a date time value of today at hour 12.

I am afraid that "today at 01:00:00" is ambiguous as you did not supply AM/PM information. AM would b

DHMS(today(),1,0,0). 1 PM is hour 13, so DHMS(today(),13,0,0);

Tom — Tue, 12 Jul 2022 14:19:28 GMT

Might be faster to use a WHERE, especially if the source is some external database.

data Miles1;
  set Miles;
  where CreatedDate1 < "%sysfunc(today(),date9.):01:00:00"dt ;
run;

ccaudillo100 — Tue, 12 Jul 2022 14:25:31 GMT

Thank you! This worked quick and perfectly!