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 (September 2000, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.


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