| Date: | Fri, 7 Oct 2011 07:15:44 -0400 |
|---|
| Reply-To: | Nat Wooding <nathani@VERIZON.NET> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Nat Wooding <nathani@VERIZON.NET> |
|---|
| Subject: | Re: keep the first time record |
|---|
| In-Reply-To: | <201110071032.p974Fxjs012464@waikiki.cc.uga.edu> |
|---|
| Content-Type: | text/plain; charset="US-ASCII" |
|---|
Stanley
This is untested code:
Proc sort;
By client_no funding_date;
Run;
*this is needed only if the data are not sorted;
Data Stan;
Set stan;
By client_no ;
If first.client_no;
Run;
Nat Wooding
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Stanley
Luo
Sent: Friday, October 07, 2011 6: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!! :)
| 
