Prev: SAS vs. SPLUS vs. SAS
Next: time-to-event vs Age in PROC PHREG
From: Joe Matise on 11 Dec 2009 16:52
No, SQL does not process data in a way that works for FIRST and LAST. You
can sometimes use MIN() and MAX() to work out first/last, if you have a
secondary sort criteria.

If you post your complete question/problem, there are a lot of different
ways that this can be addressed, and the list would be able to suggest
alternative solutions.

-Joe

On Fri, Dec 11, 2009 at 3:49 PM, Doug Leonard <dleona1(a)state.wy.us> wrote:

> Is there any way to do something like a first. or last. record selection
> from a data step within SAS SQL?
>
 | 
Pages: 1
Prev: SAS vs. SPLUS vs. SAS
Next: time-to-event vs Age in PROC PHREG