topic Re: Text DateTime Field to SAS DateTimeField in SAS Programming

Text DateTime Field to SAS DateTimeField

alan0101 — Fri, 28 Nov 2014 08:39:43 GMT

Hi. I have a SAS dataset text field which looks as follows 2014-11-27 07:02:33.608355

How do I convert this to a SAS DateTime Format field ?

Re: Text DateTime Field to SAS DateTimeField

RW9 — Fri, 28 Nov 2014 12:16:16 GMT

The usual way is by input(variable,dateformat)

With regards to your format, it is a sort of iso date, so other than the 608355 (which to be honest I would have to look up, probably timezone offset or something), you could do:

input(substr(variable,1,10)||"T"||substr(12,5)||":00",e8601dt.)

Just a matter of pulling out the info you need.

Re: Text DateTime Field to SAS DateTimeField

Ksharp — Fri, 28 Nov 2014 14:03:46 GMT

Try informat: anydtdtm.

data x;
 a='2014-11-27 07:02:33.608355';
 b=input(a,anydtdtm30.);
 format b datetime.;
 run;

Xia Keshan

Re: Text DateTime Field to SAS DateTimeField

jdmarino — Fri, 28 Nov 2014 14:27:51 GMT

Given that your input has microsecond precision, you may also find this thread useful:

https://communities.sas.com/message/223311#223311

Re: Text DateTime Field to SAS DateTimeField

alan0101 — Mon, 01 Dec 2014 07:34:40 GMT

Many thanks Xia - your proposal works perfectly.