Creating a datetime var out of a string date

[frakje]

Hallo

I'm dealing with a problem I hope you guys can help me with.

I have a date var which is located as a character variable.

Date = '2010-07-12 12:20:51'

I want to convert it into a sas date with time registrated. Probably on the format datetime16.

How can I do that?

Thanks for the help.

Kind regard Frank.

[Kurt_Bremser · Accepted solution]

numdate = input(chardate,e8601dt19.);
format numdate e8601dt19.;

The e8601dt informat will do the conversion. Personally, I prefer formats with a ymdhms order.

[frakje]

Thank you KurtBremser it worked fine!

[Reeza]

Please mark the question as answered - Kurt's solution.