topic Convert Character ISO datetime into datatime in SAS Programming

Convert Character ISO datetime into datatime

harigottala0 — Fri, 26 Aug 2022 12:40:52 GMT

Dear All,

I need to convert the Character ISO datetime into datetime format in sas.

Here is the character datetime format.

2022-06-10T09:23:45+5:30

Thanks,

Narahari

Re: Convert Character ISO datetime into datatime

jklaverstijn — Fri, 26 Aug 2022 13:05:15 GMT

Hi,

Please have a look at the SAS doc on ISO 8601 (in)formats.

Your code would look something like this:

data _null_;
	format dt datetime21.;
	string = '2022-06-10T09:23:45+05:30';
	dt = input(string, e8601dz25.);
	put string= dt=;
	cards;
run;

In my haste I could not get it to work without 0-prefixing the time zone. This may very well be the way ISO wants it. If I read the wiki on ISO 8601 I think I am right and it should be "+05:30".

Hope this helps,

- Jan.

Re: Convert Character ISO datetime into datatime

harigottala0 — Fri, 26 Aug 2022 14:49:43 GMT

Thank you Jan