title: SAS: update with join?
body: <p>I am trying to update values of test1.control_s from table <code>test_ctrl.control_s</code>.</p>
  
  <p>I am using this code:</p>
  
  <pre><code>proc sql;
  
  update test1
  set control_s= (select control_s 
  from test_ctrl
  inner join test1
  on test1.custno=test_ctrl.custno
  and test1.accno=test_ctrl.accno);
  
  quit;
  </code></pre>
  
  <p>I am dealing with million records. I have to use join but I am not able to.</p>