topic How to convert date9. to iso8601 format ? in SAS Programming

How to convert date9. to iso8601 format ?

bobbyc — Mon, 21 Mar 2016 14:08:55 GMT

How do I convert DATE9. format to ISO8601 date format ?

I need to convert the 10JAN2011 to 2011-01-10.

Is there a way to do this ?

Re: How to convert date9. to iso8601 format ?

RW9 — Mon, 21 Mar 2016 14:40:18 GMT

Well, that example, is not necessarily ISO date, it is YYYY-MM-DD foramt which is part of ISO. You would likely do it:

isodate=put(your_date9_var,yymmdd10.);

E.g.:

data tmp;
  a="15FEB2015"d;
  b=put(a,yymmdd10.);
run;

Re: How to convert date9. to iso8601 format ?

Reeza — Mon, 21 Mar 2016 14:45:25 GMT

Formats only control the display of the variable.

If you need to change the format, use a format statement. This keeps your variable as a date so that you can do calculations later on, such as duration.

format variable yymmdd10.;

Otherwise, if you want a character variable use PUT() function as demonstrated in the other answer.