topic Re: Remove datetimes with 00 in seconds in SAS Programming

Remove datetimes with 00 in seconds

Caetreviop543 — Thu, 23 Apr 2020 15:25:33 GMT

I have a datetime variable that looks like this:

06JAN17:14:30:00

05APR15:10:15:15

07JUN12:08:12:05

08JUN15:09:10:00

07JUN16:11:12:13

Is there a straightforward way to remove datetimes with 00 seconds, so that the output looks like this:

05APR15:10:15:15

07JUN12:08:12:05

07JUN16:11:12:13

Re: Remove datetimes with 00 in seconds

Reeza — Thu, 23 Apr 2020 15:29:16 GMT

if second(datetime) = 0 then delete;

@Caetreviop543 wrote:

I have a datetime variable that looks like this:

06JAN17:14:30:00

05APR15:10:15:15

07JUN12:08:12:05

08JUN15:09:10:00

07JUN16:11:12:13

Is there a straightforward way to remove datetimes with 00 seconds, so that the output looks like this:

05APR15:10:15:15

07JUN12:08:12:05

07JUN16:11:12:13

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p00gnqetase0i9n1rshg4sz5t607.htm&docsetVersion=9.4&locale=en

Re: Remove datetimes with 00 in seconds

Caetreviop543 — Thu, 23 Apr 2020 15:32:14 GMT

Thank you!

Re: Remove datetimes with 00 in seconds

ballardw — Thu, 23 Apr 2020 16:34:41 GMT

If any of your values have fractional seconds and your current display format does not show them you could have a value that appears to have "zero seconds" still in your data.

Example code:

data example;
   x = '01JAN2020:15:30:59.888'dt;
   put x datetime18.;
run;

The log will show the time rounded to seconds, i.e. :00