非常感谢 nice2u回答了我问的SQL问题, it works!

附nice2u的CODE, 在SAS环境下也work了.

select min(begdate),enddate

from (

select begdate,
enddate
from sometable
where enddate = (
select max(enddate)
from sometable
)
)
group by
enddate