topic Re: Creating a datetime var out of a string date in New SAS User https://communities.sas.com/t5/New-SAS-User/Creating-a-datetime-var-out-of-a-string-date/m-p/573016#M12415 <P>Thank you KurtBremser it worked fine!</P> Fri, 12 Jul 2019 09:13:41 GMT frakje 2019-07-12T09:13:41Z Creating a datetime var out of a string date https://communities.sas.com/t5/New-SAS-User/Creating-a-datetime-var-out-of-a-string-date/m-p/573008#M12408 <P>Hallo</P><P>&nbsp;</P><P>I'm dealing with a problem I hope you guys can help me with.</P><P>I have&nbsp;a date var which is located as a&nbsp;character variable.</P><P>&nbsp;</P><P>Date = '2010-07-12 12:20:51'</P><P>I want to convert it into a sas date with time registrated. Probably on the format datetime16.</P><P>&nbsp;</P><P>How can I do that?</P><P>&nbsp;</P><P>Thanks for the help.</P><P>&nbsp;</P><P>Kind regard Frank.</P> Fri, 12 Jul 2019 08:47:51 GMT https://communities.sas.com/t5/New-SAS-User/Creating-a-datetime-var-out-of-a-string-date/m-p/573008#M12408 frakje 2019-07-12T08:47:51Z Re: Creating a datetime var out of a string date https://communities.sas.com/t5/New-SAS-User/Creating-a-datetime-var-out-of-a-string-date/m-p/573011#M12410 <PRE><CODE class=" language-sas">numdate = input(chardate,e8601dt19.); format numdate e8601dt19.;</CODE></PRE> <P>The e8601dt informat will do the conversion. Personally, I prefer formats with a ymdhms order.</P> Fri, 12 Jul 2019 08:58:04 GMT https://communities.sas.com/t5/New-SAS-User/Creating-a-datetime-var-out-of-a-string-date/m-p/573011#M12410 Kurt_Bremser 2019-07-12T08:58:04Z Re: Creating a datetime var out of a string date https://communities.sas.com/t5/New-SAS-User/Creating-a-datetime-var-out-of-a-string-date/m-p/573016#M12415 <P>Thank you KurtBremser it worked fine!</P> Fri, 12 Jul 2019 09:13:41 GMT https://communities.sas.com/t5/New-SAS-User/Creating-a-datetime-var-out-of-a-string-date/m-p/573016#M12415 frakje 2019-07-12T09:13:41Z Re: Creating a datetime var out of a string date https://communities.sas.com/t5/New-SAS-User/Creating-a-datetime-var-out-of-a-string-date/m-p/573129#M12451 Please mark the question as answered - Kurt's solution. Fri, 12 Jul 2019 15:05:37 GMT https://communities.sas.com/t5/New-SAS-User/Creating-a-datetime-var-out-of-a-string-date/m-p/573129#M12451 Reeza 2019-07-12T15:05:37Z