title: Convert string column 'dd.mm.yyyy hh:mm:ss' into a SAS date format 'dd.mm.yyyy'
body: <p>I need to write a script that converts symbolic data to data format. I have a table with column <code>date</code>, containing strings like <code>28.01.2017 09:23:14</code>. I need to convert them to a date format <code>28.23.2017</code>. 
  i tried:</p>
  
  <pre><code>data SMS_STAT;
      set SMS_STAT;
      date = input(date, DDMMYY9.);
      put date = DDMMYY9.; 
   run;
  </code></pre>
  
  <p>Also, i tried diffrent formats in <code>date</code> and <code>put</code>, but that didn't help: it converts to a <code>.</code></p>
  
  <p>I have substringed <code>28.01.2017 09:23:14</code> to <code>28.01.2017</code> so now, i want to make a date from it.</p>