topic Re: ISO Date Format ("2018-09-04T14:11:58.000Z") into Date in SAS Programming

ISO Date Format ("2018-09-04T14:11:58.000Z") into Date

RB1Kenobi — Wed, 29 Apr 2020 07:10:53 GMT

Hello, I have in a string value the date time in this format "2018-09-04T14:11:58.000Z". I've been trying the SAS ISO formats within an INPUT statement but can't identify the correct format from the support documentation SAS ISO Support Documentation

Re: ISO Date Format ("2018-09-04T14:11:58.000Z") into Date

Astounding — Wed, 29 Apr 2020 07:40:52 GMT

Try:

datevar = input(charvar, yymmdd10.);

You would probably want to apply a format to DATEVAR.

Re: ISO Date Format ("2018-09-04T14:11:58.000Z") into Date

Kurt_Bremser — Wed, 29 Apr 2020 07:46:50 GMT

See here:

data test;
dt_char = "2018-09-04T14:11:58.000Z";
dt_num = input(dt_char,e8601dz24.);
format dt_num e8601dx32.3;
run;

Result:

1	2018-09-04T14:11:58.000Z	2018-09-04T16:11:58.000+02:00

(Austria, DST)

Re: ISO Date Format ("2018-09-04T14:11:58.000Z") into Date

RB1Kenobi — Wed, 29 Apr 2020 09:15:32 GMT

To add some context, I know it could be handled using MDY or similar but I want to transform the field within a JSON Map so to know the exact informat/format would help to keep the syntax simple.

Re: ISO Date Format ("2018-09-04T14:11:58.000Z") into Date

RB1Kenobi — Wed, 29 Apr 2020 11:08:50 GMT

I had some success with the code below

data textstring;
iso = '2018-09-04T14:11:58.000Z'; output;
iso = '2019-10-01T14:11:58.000Z'; output;
iso = '2018-09-04T14:11:58.000Z'; output;
iso = '2019-10-01T14:11:58.000Z'; output;
iso = '2019-10-01T14:44:42.000Z'; output;
run;

data t1;
set textstring;
informat t1  E8601DT16.;
format t1  E8601DT16.   t2 date9.   t3 time5.;

t1= input(iso,E8601DT16.);
t2=datepart(t1);
t3=timepart(t1);
run;

Re: ISO Date Format ("2018-09-04T14:11:58.000Z") into Date

RB1Kenobi — Wed, 29 Apr 2020 11:11:58 GMT

Thank you for your assistance. I hadn't seen these before selecting the "solution" for the thread.

Re: ISO Date Format ("2018-09-04T14:11:58.000Z") into Date

RB1Kenobi — Wed, 29 Apr 2020 11:12:38 GMT

Thanks for your assistance. I hadn't seen these before selecting the "solution" for the thread.