topic Re: datetime format in SAS Programming

datetime format

Bal — Fri, 02 Oct 2015 19:25:22 GMT

I'm reading some file which is created by SAS API. In that file I have "2015-09-28T09:54:09.0325056-05:00" for this i want to read as datetime format.

Re: datetime format

Reeza — Fri, 02 Oct 2015 19:33:46 GMT

Have you tried the anydtdtm. format?

Re: datetime format

PGStats — Fri, 02 Oct 2015 19:42:03 GMT

Look at the informat documentation. It documents how this works

data test;
x = "2015-09-28T09:54:09.0325056-05:00";
y = input(x, B8601DZ35.);
format y datetime26.;
put _all_ ;
run;

Re: datetime format

Bal — Tue, 27 Oct 2015 18:22:59 GMT

Thank you very Much PG. It helps me.