Date:         Tue, 11 Jul 2006 12:45:09 -0400
Reply-To:     Heman Hunters <hemanhunters@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Heman Hunters <hemanhunters@GMAIL.COM>
Subject:      Proc sql and .last?

Hello (again),

short question this time: Is there an equivalent to .last and .first in
SQL? That is, can

data test2;
  set test1;
  by dummy;
  if dummy.last;
run;

be done using proc sql? If not, does anyone have a clever idea of how to
do it in an SQL statement anyway?

Thanks!