SQL and first. or last.

  • Follow


Is there any way to do something like a first. or last. record selection
from a data step within SAS SQL?
0
Reply dleona1 (13) 12/11/2009 9:49:48 PM

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@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?
>
0
Reply snoopy369 (1752) 12/11/2009 9:52:17 PM


1 Replies
182 Views

(page loaded in 0.167 seconds)


Reply: