using min to select one row from each group

[DanD]

I want to select one row for each id based on the min(date). My data looks like this:

id code date
1 38 200912
1 AG 201010
2 17 200911
2 09 200910
2 36 201010
3 12 201009

The result set should look like this:
1 38 200912
2 09 200910
3 12 201009

How do I do this?

Thanks,

Dan

[Reeza]

Two step proc sort.

proc sort data=have;
by id descending date;
run;

proc sort data=have nodupkey out=want dupout=duplicates;
by id;
run;

OR the second step can be the one below.

data first;
set have;
by id;
if first.id then output;
run;

[DanD]

Those worked great. Thanks Reeza.

[DBailey]

one step, if you don't mind potential duplicates:

proc sql;
select
t1.id,
t1.code,
t1.date
from
work.tabA t1
where
t1.date=(select min(date) from work.tabA where id=t1.id);
quit;

[DanD]

I tried it but you were right, it did have a few dupes. I need to have only one row per id. Reeza's code in an above message worked for what I need. Thanks for replying.

[Ksharp]

[pre]
data temp;
input id code $ date ;
cards;
1 38 200912
1 AG 201010
2 17 200911
2 09 200910
2 36 201010
3 12 201009
;
run;
proc sql;
select *
from temp
group by id
haveing date eq min(date)
;
quit;
[/pre]




Ksharp