Date:         Tue, 23 Oct 2007 13:34:47 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: Newbie ...heed help
Comments: To: frytz.d@gmail.com
In-Reply-To:  <1193123185.204371.327580@t8g2000prg.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Provided you have your dates stored as SAS dates which you should regardless:
 
Proc Sort
 Data = Have ;
 By Seq Date ;
Run ;
 
Data Need ;
Set Have ;
By Seq Date ;
 
If First.Date Then Output ;
 
Run ;
 
 
Toby Dunn Compromise is like telling a lie, it gets easier and easier. Each compromise you make, that becomes your standard. Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else.> Date: Tue, 23 Oct 2007 00:06:25 -0700> From: frytz.d@GMAIL.COM> Subject: Newbie ...heed help> To: SAS-L@LISTSERV.UGA.EDU> > I want to filter a dataset by removing entry with same sequence number> but older data.> > sample:> > seq# date data1 data2 data2> 0123 oct 1 abc 1234 abc123> 0426 oct 12 abc 4576 abc978> 0123 oct 18 jfk 1234 abde23> 0128 oct 1 abc 1234 abc13f> 0426 oct 21 klm 9923 99c12g> 0125 oct 15 abc 1124 abc123> 0128 Sep 15 abc 1234 abc123> > > output should be> > seq# date data1 data2 data2> 0123 oct 18 jfk 1234 abde23> 0128 oct 1 abc 1234 abc13f> 0426 oct 21 klm 9923 99c12g> 0125 oct 15 abc 1124 abc123> > > ...please advise ....> The simplier the better
_________________________________________________________________
Climb to the top of the charts!  Play Star Shuffle:  the word scramble challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct