Proc SQL query - Select Minimum Record

scb — Mon, 05 Sep 2016 16:30:34 GMT

dataset a

Date RefNo Amount

01Jun16 ABC 1000

02Jun16 ABC 1000

03Jun16 ABC 1000

01Jan16 VCV 2100

02Jan16 VCV 2100

03Jan16 VCV 2100

.......etc

May I know how to get the following dataset using proc sql? I need the minumum date record for each RefNo.

Date RefNo Amount

01Jun16 ABC 1000

01Jan16 VCV 2100

Thanks.

Re: Proc SQL query - Select Minimum Record

Reeza — Mon, 05 Sep 2016 16:31:34 GMT

proc sql;
create table want as
select *
from have
group by refno
having date=min(date);
quit;

You can filter your dataset based on the HAVING clause.