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!!  :)