topic Re: How to use proc sql on .. in SAS Procedures

How to use proc sql on ..

deleted_user — Thu, 28 Apr 2011 21:44:32 GMT

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.

Re: How to use proc sql on ..

Ksharp — Fri, 29 Apr 2011 00:58:07 GMT

[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

Re: How to use proc sql on ..

Patrick — Fri, 29 Apr 2011 03:02:01 GMT

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

Re: How to use proc sql on ..

deleted_user — Fri, 29 Apr 2011 15:55:19 GMT

Thanks Ksharp and Patrick.