Date:         Tue, 11 Mar 2008 15:32:02 -0700
Reply-To:     shanky <shankardasm@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         shanky <shankardasm@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: creating single observation from multiple observations
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi Nia,

You could try something like this:


   proc sql;
   create table need as
   select id,time,age,max(var1) as var1 ,max(var2) as var2
   from have
   group by id,age
   having max(monotonic())=monotonic()
   order by id,age;
   quit;

Hope this helps;
Shanky