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 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 7 Oct 2011 12:14:47 -0700
Reply-To:     "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Subject:      Re: keep the first time record
In-Reply-To:  <201110071032.p974Fxjs012464@waikiki.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Why are you keeping two records for the same client? Did you mean to say you wanted all records for the first date of a client?

> -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of > Stanley Luo > Sent: Friday, October 07, 2011 3:33 AM > To: SAS-L@LISTSERV.UGA.EDU > Subject: keep the first time record > > Dear SAS-Ls: > Another question is... > I want to keep the first time(the first day) transaction record of the > same client. > > For example below: > > obs Client_No funding_date Acct_nbr > 1 A2208xxxxx 2002/10/29 0103xxxA > 2 A2208xxxxx 2002/10/29 0103xxxB > 3 A2208xxxxx 2004/6/9 0103xxxC > > In my requirement, i want to keep obs 1 and 2. > Any suggestions are highly appreciated!! :)


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