topic Convert string datetime to iso8601 in SAS Procedures

Convert string datetime to iso8601

Lorenzom — Tue, 02 Sep 2014 10:00:53 GMT

Dear all.

I-m very newbie to sas and I`m getting crazy with a simple problem.

I have a variable in a dataset $25. that contains a date like 18MAR2014:11:19:42

I want to convert it in a iso8601dt format...

Using

put _datetime is8601dt.;

I get in log

put _datetime is8601dt.;

---------

ERROR 48-59: The format $IS8601DT was not found or could not be loaded.

Could you please help me?

SAS 9.3

Thank you

Re: Convert string datetime to iso8601

Loko — Tue, 02 Sep 2014 10:08:09 GMT

Hello,

Maybe you'll find this link useful:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003169814.htm

Re: Convert string datetime to iso8601

Lorenzom — Tue, 02 Sep 2014 10:27:03 GMT

Thank you Loko,

but i cannot find any example to convert string into iso format.

Could you please provide an example to convert String in to iso8601...

I can also use date and time variables to convert into iso8601...

Thank you!

Re: Convert string datetime to iso8601

RW9 — Tue, 02 Sep 2014 10:34:51 GMT

Well, its a process of reading the string in as the nearest date/time format, then just apply a format:

data a;

a="18MAR2014:11:19:42";

b=input(a,datetime19.);

format b e8601dt.;

run;

Re: Convert string datetime to iso8601

Loko — Tue, 02 Sep 2014 11:42:44 GMT

As RW9 stated - you just have to choose the appropriate format (you can find them at the link mentioned in my previous post). Ther is no format named iso860 within SAS .

Re: Convert string datetime to iso8601

Lorenzom — Tue, 02 Sep 2014 12:45:19 GMT

thank you everybody.

it works!!

Thanks RW9 for the working example