title: proc sql mode function
body: <p>I know that in mysql there's no aggregate function to calculate the mode (you have to do many steps). But I think in a proc sql should be possible. Is there a way to do so?
  The code would be sth like this:</p>
  
  <pre><code>select phones, mode(state_id)as state from
  xxx.listings_abr3 
  group by phones
  </code></pre>
  
  <p>the error is:</p>
  
  <p>Function MODE could not be located.</p>
  
  <p>thanks!</p>