waitalone11 发表于 2010-3-2 11:07 
数据集格式如下:
种类 年份 时间
a 2007 01mar 2007
a 2007 05mar2007
a 2008 01apr2008
a 2008 05apr 2008
a 2009 01jan2009
a 2009 04jan2009
b 2007 01mar 2007
b 2007 05mar2007
b 2008 01apr2008
b 2008 05apr 2008
b 2009 01jan2009
b 2009 04jan2009
我想知道每个类每年出现的最早时间?谢谢!每个类每年对应时间很多。
I give a SQL approach. The results should be the same as that from 醉_清风's. See below,
data a;
input id:$2. year:4. tme:date9.;
cards;
a 2007 01mar2007
a 2007 05mar2007
a 2008 01apr2008
a 2008 05apr2008
a 2009 01jan2009
a 2009 04jan2009
b 2007 01mar2007
b 2007 05mar2007
b 2008 01apr2008
b 2008 05apr2008
b 2009 01jan2009
b 2009 04jan2009
;
run;
proc sql;
select id, year, min(tme) as min_time format=yymmdd10.
from a
group by 1,2
order by 1,2
;
quit;