Remove a duplicate and hold min date value

[Sathish_jammy]

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!

[ChrisNZ · Accepted solution]

Like this?

proc sort data=HAVE out=TMP ;

  by ID COMMENTS DATE;

run;

proc sort data=TMP out=WANT nodupkey;

  by ID COMMENTS;

run;