How to use DATETIME in WHERE clause in SAS PROC SQL
<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>