title: SAS proc sql error. The following columns were not found in the contributing tables:
body: <p>I am running the below proc sql code in SAS. I get the error as 'The following columns were not found in the contributing tables: I really dont understand where is the mistake.</p>
  
  <pre><code>proc sql;
   create table sum_Med
    as
    select ID, count(prop_ID) as count,
    (case 
      when (count &gt;= 5) then 1 else 0 end) as poli
    from dist_Id
   group by ID;
  quit;
  
  </code></pre>
  
  <p>Error below:</p>
  
  <blockquote>
    <p>Error The following columns were not found in the contributing tables: count</p>
  </blockquote>