Removing duplicates rows by max date

[PRISCILABRA]

I WOULD LIKE TO REMOVE DUPLICATES FROM A VARIABLE KEY TO THE MAXIMUM DATE OF ANOTHER VARIABLE AND I DO NOT KNOW HOW, CAN YOU HELP ME?

Example:

COLUMN A(KEY)  COLUMN B(DATE)

1                             20170422

1                             20170423

1                             20170425

I NEED THE SAME KEY WITH MAXIMUM DATE, REMOVING THE DUPLICATED KEYS KEEPING THE KEYWORK WITHOUT DUPLICATION FOR THE LAST DATE AVAIABLE TO THIS KEY. CAN YOU UNDERSTAND ME? TKS

[novinosrin]

proc sql;

select *

from have

group by key

having date=max(date);

quit;/*date is column b*/

[PRISCILABRA]

Sorry for my answer, thanks a lot for your help.

[Astounding]

SAS contains tools to handle this:

proc sort data=have;

by key date;

run;

data want;

set have;

by key date;

if last.key;

run;

[RW9]

Nope, can't understand you, maybe your CapsLock is stuck?  Maybe sort the data in order, then take last or first value?