title: SAS PROC SQL update with inner join
body: <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>