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..
How about
data test;
val='2021-08-05T14:02:57.777-05:00';
dt = input(val, anydtdtm19.);
format dt datetime19.;
run;
How about
data test;
val='2021-08-05T14:02:57.777-05:00';
dt = input(val, anydtdtm19.);
format dt datetime19.;
run;
data have; val='2021-08-05T14:02:57.777-05:00'; want=input(val,e8601dt19.); format want e8601dt.; run;
Thanks @PeterClemmensen and @Ksharp
This works..
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.