Date:         Tue, 28 Dec 2004 10:30:55 -0500
Reply-To:     Srinivas Reddy Valisekkagari <reddy.srinivas@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Srinivas Reddy Valisekkagari <reddy.srinivas@GMAIL.COM>
Subject:      Re: Proc SQL Grouping

HI,
  Some correction(in order by line) in the Query that i posted earlier :

  PROC SQL noprint;
    CREATE Table T2
    SELECT  DISTINCT A,B,C,D,F,
            MAX(E) AS MAX_DT
             FROM T1
             WHERE F IN ('O','H')
             GROUP BY  A,B,C,D,F
             ORDER BY A,B,C,D,MAX_DT DESC
  QUIT;


-Reddy