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
|
|