Just use - proc sort data = mydataset nodupkey; by acct_no name; run; Or, if you have to use SQL - proc sql noprint; create table key_keep as select distinct acct_no, name, date from mydataset group by acct_no, name having date = min(date); create table mydataset2 as select a.* from mydataset a INNER JOIN key_keep b ON a.acct_no = b.acct_no and a.name = b.name and a.date = b.date; quit; I think that should do the trick.
... View more