Remove a duplicate and hold min date value

Sathish_jammy — Thu, 24 Jan 2019 10:36:36 GMT

Hi community,

I want to sort out the duplicate comments and holds the min date by ID in my table.

For Exmpl

data have;
input id comments$ date mmddyy10.;
cards;
100 cmmnt1 10/11/2017
105 cmmnt3 12/12/2018
100 cmmnt1 09/10/2012
108 cmmnt2 07/08/2016
100 cmmnt2 08/11/2015
run;
proc print data = have;
format date mmddyy10.;
run;

For this, my output should

100 cmmnt1 09/10/2012

100 cmmnt2 08/11/2015

105 cmmnt3 12/12/2018

108 cmmnt2 07/08/2016

Please help me to get this output.

Thanks in advance!

Re: Remove a duplicate and hold min date value

ChrisNZ — Thu, 24 Jan 2019 11:00:41 GMT

Like this?

proc sort data=HAVE out=TMP ;

by ID COMMENTS DATE;

run;

proc sort data=TMP out=WANT nodupkey;

by ID COMMENTS;

run;

topic Remove a duplicate and hold min date value in SAS Programming

Remove a duplicate and hold min date value

Re: Remove a duplicate and hold min date value