Text DateTime Field to SAS DateTimeField

[alan0101]

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 ?

[RW9]

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.

[Ksharp · Accepted solution]

Try informat:  anydtdtm.

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

Xia Keshan

[alan0101]

Many thanks Xia - your proposal works perfectly.

[jdmarino]

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

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