Date:         Wed, 6 Sep 2000 21:55:09 GMT
Reply-To:     John Smith <anirdesh@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         John Smith <anirdesh@HOTMAIL.COM>
Subject:      SAS Question
Content-Type: text/plain; format=flowed

I have data as follows :

name $ vstdat $ doc_cod treat $ ;

x  920527 07 abca
x  930527 07 abcx
x  960527 08 abcy
x  980527 08 abcx
x  000527 08 abcz

I want resultant record as follows :

x   960527 08  abcz

When doc_cod is same (& must be latest/recent),
the vstdat should be minimum date of all available vstdat
for the same doc_cod and treat(ment) should be the most recent.

Any help with SQL ?

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.