LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2011, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 13 Oct 2011 03:37:36 -0400
Reply-To:     Stanley Luo <shanminglo@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Stanley Luo <shanminglo@GMAIL.COM>
Subject:      Re: Select the last 6 records of each ID

Sorry my bad, it should be "Select the LATEST 6 records of each ID"

Regards, Stanley

On Thu, 13 Oct 2011 03:34:01 -0400, Stanley Luo <shanminglo@GMAIL.COM> wrote:

>Dear SAS-Ls: >The question is... >I want to select the last 6 transaction records of the same client. >Though some clients may have less than 6 records. > >For example below: > >obs Client_No transaction_date > 1 A1015XXXX 2005/2/2 > 2 A1015XXXX 2005/1/1 > 3 A1015XXXX 2004/12/12 > 4 A1015XXXX 2004/11/11 > 5 A1015XXXX 2004/10/10 > 6 A1015XXXX 2004/9/9 > 7 A1015XXXX 2004/8/8 > 8 A1015XXXX 2004/7/7 > 9 A1031XXXX 2004/8/8 >10 A1102XXXX 2002/10/10 >11 A1202XXXX 2007/12/6 >12 A1202XXXX 2007/11/6 >13 A1202XXXX 2007/10/6 >14 A1202XXXX 2007/9/6 >15 A1202XXXX 2007/8/6 >16 A1202XXXX 2007/7/2 >17 A1202XXXX 2007/6/12 >18 A1202XXXX 2007/5/15 > >It's kinda urgent, so any responses are highly appreciated!! >Thanks in advance.


Back to: Top of message | Previous page | Main SAS-L page