title: Filter a SAS dataset to contain only identifiers given in a list
body: <p>I am working in SAS Enterprise guide and have a one column SAS table that contains unique identifiers (id_list).</p>
  
  <p>I want to filter another SAS table to contain only observations that can be found in id_list.</p>
  
  <p>My code so far is:</p>
  
  <pre><code>proc sql noprint;
      CREATE TABLE test AS
      SELECT *
      FROM  data_sample
      WHERE id IN id_list
  quit;
  </code></pre>
  
  <p>This code gives me the following errors:</p>
  
  <pre><code>Error 22-322: Syntax error, expecting on of the following: (, SELECT.
  </code></pre>
  
  <p>What am I doing wrong?</p>
  
  <p>Thanks up front for the help. </p>