https://communities.sas.com/t5/SAS-Programming/Convert-String-to-date/m-p/365395#M86775 <P>How to convert string such as 14072017 into date format 14/07/2017?</P> Thu, 08 Jun 2017 14:33:58 GMT Aditi24 2017-06-08T14:33:58Z https://communities.sas.com/t5/SAS-Programming/Convert-String-to-date/m-p/365395#M86775 <P>How to convert string such as 14072017 into date format 14/07/2017?</P> Thu, 08 Jun 2017 14:33:58 GMT https://communities.sas.com/t5/SAS-Programming/Convert-String-to-date/m-p/365395#M86775 Aditi24 2017-06-08T14:33:58Z https://communities.sas.com/t5/SAS-Programming/Convert-String-to-date/m-p/365396#M86776 <P>like this</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data have; string_date = '14072017'; run; data want; set have; num_date = input(string_date, ddmmyy10.); format num_date ddmmyy10.; run;</CODE></PRE> Thu, 08 Jun 2017 14:36:09 GMT https://communities.sas.com/t5/SAS-Programming/Convert-String-to-date/m-p/365396#M86776 PeterClemmensen 2017-06-08T14:36:09Z