title: SAS Proc sql row number
body: <p>How do I get the row number of an observation in proc sql, similar to _N_ for a datastep in proc sql?</p>
  
  <p>For example</p>
  
  <pre><code>proc sql outobs=5;
      select case mod(&lt;something&gt;, 2)
      when 0 then "EVEN"
      else "ODD" 
      end
      from maps.africa
  end;
  </code></pre>
  
  <p>Want:</p>
  
  <pre><code>Row
  ----------
      1 odd
      2 even
      3 odd
      .
      .
      .
  </code></pre>