topic Re: Convert string to datetime ignore timezone in SAS Programming

Convert string to datetime ignore timezone

NN — Fri, 05 Nov 2021 12:02:29 GMT

Hi Everyone,
I have a datetime string with Timezone in it
val='2021-08-05T14:02:57.777-05:00'
Is there a way to convert this to datetim19. ignoring the timezone.
so that the time remains 14:02:57

Thanks..

Re: Convert string to datetime ignore timezone

PeterClemmensen — Fri, 05 Nov 2021 12:36:21 GMT

How about

data test;
   val='2021-08-05T14:02:57.777-05:00';
   dt = input(val, anydtdtm19.);
   format dt datetime19.;
run;

Re: Convert string to datetime ignore timezone

Ksharp — Fri, 05 Nov 2021 12:37:02 GMT

data have;
val='2021-08-05T14:02:57.777-05:00';
want=input(val,e8601dt19.);
format want e8601dt.;
run;

Re: Convert string to datetime ignore timezone

NN — Fri, 05 Nov 2021 13:56:45 GMT

Thanks @PeterClemmensen and @Ksharp
This works..