title: SAS PROC SQL NOT CONTAINS multiple values in one statement
body: <p>In PROC SQL, I need to select all rows where a column called "NAME" does not contain multiple values "abc", "cde" and "fbv" regardless of what comes before or after these values. So I did it like this:</p>
  
  <pre><code>SELECT * FROM A WHERE
    NAME NOT CONTAINS "abc" 
    AND
    NAME NOT CONTAINS "cde"
    AND
    NAME NOT CONTAINS "fbv";
  </code></pre>
  
  <p>which works just fine, but I imagine it would be a headache if we had a hundred of conditions. So my question is - can we accomplish this in a single statement in PROC SQL? 
  I tried using this:</p>
  
  <pre><code>SELECT * FROM A WHERE 
    NOT CONTAINS(NAME, '"abc" AND "cde" AND "fbv"');
  </code></pre>
  
  <p>but this doesn't work in PROC SQL, I am getting the following error:</p>
  
  <blockquote>
    <p>ERROR: Function CONTAINS could not be located.</p>
  </blockquote>
  
  <p>I don't want to use LIKE.</p>