How to use proc sql on ..

[deleted_user]

My dataset looks like this:

Subject START STARTL END ENDL
1001 10Jan2010 10Jan10 12Jan2010 12Jan10
1001 15Jan2010 15Jan10 17Jan2010 17Jan10
1001 17Jan2010 17Jan10 18Jan2010 18Jan10
1001 19Jan2010 19Jan10 20Jan2010 20Jan10

I want to get min(start) and corresponding startL, max(start) and corresponding startL per subject. How can I do this using proc sql.

[Ksharp]

[pre]
data temp;
input Subject (START STARTL END ENDL) (: date9.);
format START STARTL END ENDL date9.;
datalines;
1001 10Jan2010 10Jan10 12Jan2010 12Jan10
1001 15Jan2010 15Jan10 17Jan2010 17Jan10
1001 17Jan2010 17Jan10 18Jan2010 18Jan10
1001 19Jan2010 19Jan10 20Jan2010 20Jan10
;
run;
proc sql;
select subject,start,startl
from temp
group by subject
having start=min(start)
;
quit;
[/pre]

Ksharp

[Patrick]

proc sql;
select subject,start,startl,end,endl
from temp
group by subject
having start=min(start) or start=max(start)
;
quit;

[deleted_user]

Thanks Ksharp and Patrick.