topic Re: How to remove extra :00 in time in SAS Programming

How to remove extra :00 in time

Aayushi_17 — Mon, 24 Feb 2020 07:12:57 GMT

How to remove extra :00 in time

for eg:
input:
'2019-03-30T20:39:00'
'2019-01-30T19:15:00'
'2019-01-30'

desried output:
'2019-03-30T20:39'
'2019-01-30T19:15'
'2019-01-30'

Thanks in advance

Re: How to remove extra :00 in time

Kurt_Bremser — Mon, 24 Feb 2020 07:14:32 GMT

A datetime value will always have a time component; if you want to keep a missing time component as such, you have to store date and time in separate variables.

What format is your data source? Remote database, text file, Excel?

Re: How to remove extra :00 in time

Kurt_Bremser — Mon, 24 Feb 2020 07:15:41 GMT

To just omit displaying the seconds, use the e8601dt16. format.

Re: How to remove extra :00 in time

Ksharp — Mon, 24 Feb 2020 12:02:00 GMT

Is it a STRING ?

data have;
input x $40.;
want=prxchange("s/:00'$/'/",1,strip(x));
datalines4;
'2019-03-30T20:39:00'
'2019-01-30T19:15:00'
'2019-01-30'
;;;;