SAS PROC SQL update with inner join
<p>Last time I checked, this is completely legit SQL code that even Access can handle. Not sure why I'm getting the following error from SAS</p>

<pre><code>UPDATE fu_coding 
INNER JOIN old_form16 
    ON fu_coding.CSPCCID = old_form16.CSPCCID 
SET fu_coding.CHANGED = 1
WHERE fu_coding.NEW_DIAG &lt;&gt; old_form16.NEW_DIAG;
</code></pre>

<p>Error is:</p>

<pre><code>18311      INNER JOIN old_form16
           -----
       22
       76
ERROR 22-322: Syntax error, expecting one of the following: a name, (, '.', AS, SET.
ERROR 76-322: Syntax error, statement will be ignored.
</code></pre>

<p>I really appreciate your help with this!</p>