Remove datetimes with 00 in seconds

[Caetreviop543]

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

[Reeza · Accepted solution]

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...

[Caetreviop543]

Thank you!

[ballardw]

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