title: How to use DATETIME in WHERE clause in SAS PROC SQL
body: <p>I have this data in a SAS table: 01Sep2016:21:31:27</p>
  
  <p>I want to do this:</p>
  
  <pre><code>PROC SQL;
  UPDATE lib1.tablename1
  set Valid_From = '2000-01-01 00:00:00'dt
  WHERE Valid_From = '1Sep2016:21:31:26'dt;
  QUIT;
  </code></pre>
  
  <p>But the WHERE clause doesn't match. What is the correct format for the datetime value?</p>