title: Getting last row of table in SAS SQL
body: <p>Hello I am doing the following data step where I extract the last line of a table.
  How can I do the same in a <code>proc sql</code>, I am hoping it will be much quicker if I can access directly the last row?</p>
  
  <pre><code>data refTable;
      set vhd(keep= v69c1ec v69dhec v69nbms fixing where=(fixing = 'continu')) end=eof;
      if eof then output;
      by v69dhec v69nbms;
  run;
  </code></pre>
  
  <p>Thanks</p>