topic Re: Removing duplicates rows by max date in SAS Enterprise Guide

Removing duplicates rows by max date

PRISCILABRA — Wed, 10 May 2017 14:32:04 GMT

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

Re: Removing duplicates rows by max date

novinosrin — Wed, 10 May 2017 14:36:06 GMT

proc sql;

select *

from have

group by key

having date=max(date);

quit;/*date is column b*/

Re: Removing duplicates rows by max date

Astounding — Wed, 10 May 2017 14:37:16 GMT

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;

Re: Removing duplicates rows by max date

RW9 — Wed, 10 May 2017 14:51:10 GMT

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

Re: Removing duplicates rows by max date

PRISCILABRA — Wed, 31 May 2017 20:42:10 GMT

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