title: SAS datastep/SQL select latest record from multiple records with same ID
body: <p>For example I have a dataset as below:</p>
  
  <pre><code>id Date
  1  2000/01/01
  1  2001/01/01
  1  2002/01/01
  2  2003/01/01
  </code></pre>
  
  <p>By datastep or sql, how could I get the record with id = 1 and latest Date 2002/01/01?
  Help is appreciated and thanks in advance.</p>