title: SQL remove Dups and keep longer columns value
body: <p>I have questions about <strong>SQL</strong> on <strong>SAS</strong>, and the problem would be similar to following.</p>
  
  <pre><code>ID|LName|FName|Address
  1 |A    |B    |1 Street
  1 |A    |B    |1 Street **APT 101**
  2 |A    |B    |1 Street
  2 |A    |B    |1 Street **APT 101**
  </code></pre>
  
  <p>is that possible to check ID first, then if address is longer than another one then keep the longer one?</p>
  
  <hr>