title: Delete rows from A matching rows in B in SAS
body: <p>I currently have a table with multiple duplicates across the primary key columns due to a lack of integrity checks. Be that as it may, I'm attempting to remove the duplicates. The problem is, there's no <code>id</code> column, which means that finding the duplicates is nontrivial.</p>
  
  <p>My current solution involves using the <code>count(*)... having</code> construct to create a second table, and selecting the rows to be deleted into there. My problem is that the SAS <code>delete</code> command doesn't allow for the following:</p>
  
  <pre><code>proc sql;
  delete from TableA
  where (v1,v2,v3) in TableB
  </code></pre>
  
  <p>Is there any way to delete from one table based on the contents of another?</p>