title: Why am I getting SAS error when running the enclosed proc sql code
body: <p>I cannot understand why I am getting the following errors when running the code below:</p>
  
  <p>27         WHERE (FC_ATTORNEY_ID, REC_CHNG_DT) IN
                                  _
                                  79
  ERROR 79-322: Expecting a (.</p>
  
  <p>35         ) AND REC_CHNG_CD In ('A','C')
  36         ;
             _
             79
  ERROR 79-322: Expecting a ).</p>
  
  <pre><code>proc sql;
  
  create table test as
  SELECT DISTINCT 
  FC_ATTORNEY_ID, FC_ATTORNEY_NM, REC_CHNG_DT
  FROM RDX_BDE.T_FORECLOSURE T_FORECLOSURE
  WHERE (FC_ATTORNEY_ID, REC_CHNG_DT) IN
  (
  SELECT
  FC_ATTORNEY_ID
  , MAX (REC_CHNG_DT) AS LST_DT
  FROM RDX_BDE.T_FORECLOSURE T_FORECLOSURE
  WHERE  REC_CHNG_CD In ('A','C')
  GROUP BY FC_ATTORNEY_ID
  ) AND REC_CHNG_CD In ('A','C')
  ;quit;
  </code></pre>
  
  <p>trying to avoid the two errors I described.  I received this code from another programmer however they are using TOAD, not SAS</p>