topic Date conversion to iso 8601 in SAS Programming

Date conversion to iso 8601

Aayushi_17 — Thu, 08 Nov 2018 12:27:41 GMT

what syntax can i use to convert this date format "14MAY2008:00:00:00" to "2008-05-14T00:00" to iso 8601 format ?

Re: Date conversion to iso 8601

RW9 — Thu, 08 Nov 2018 12:36:44 GMT

All formats and informats are detailed here:

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

I would say the first is a datetime informat, the wanted result is an e8601dt format.

Re: Date conversion to iso 8601

SuryaKiran — Fri, 09 Nov 2018 13:14:32 GMT

Are you missing "Seconds" in your required format. Is it supposed to be " 2008-05-14T00:00:00 ". If you don't want the seconds to be included then, then only option will be storing the values as charactes because any 8601 ISO format includes seconds.

If you require seconds too, then use E8601DT19. format if the values are stored as actual date time values. If they are stored as character values then you may need to convert them using INPUT() function.

/* If actual values are as character */
data test;
format date E8601DT20.;
date_Char='14MAY2008:00:00:00';
date=INPUT(date_Char,datetime.);

run;

/* Stored as actual date */
data test;
format date E8601DT20.;
date='14MAY2008:00:00:00'dt;
run;

Re: Date conversion to iso 8601

Aayushi_17 — Fri, 09 Nov 2018 12:12:46 GMT

Thank you so much all