Date:         Wed, 18 Apr 2007 16:55:13 -0500
Reply-To:     "Huang, JS" <Huang.JS@PRINCIPAL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Huang, JS" <Huang.JS@PRINCIPAL.COM>
Subject:      Re: Dups and date - urgent
Comments: To: sdlenter <sdlentert@AOL.COM>
In-Reply-To:  A<1176932522.324991.189670@n76g2000hsh.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

This is an approach:

data Given;
  input F1 $ F2 $  F3 $  F4 $ date:yymmdd8.;
  format date mmddyy10.;
  datalines;
ab   ff  gg     hg   20070505
ab   ff   gg    jj    20040701
ab  fh   ht    kkk   20040404
ab  ff    gg   gggg  20040508
;

proc sort data=Given;
  by F1 F2 F3 date;
run;

data Result;
  set Given;
    by F1 F2 F3;
  if first.F3 then output;
run;

proc print;
run;

***** Output *****
                                         The SAS System       16:51
Wednesday, April 18, 2007   4

                           Obs    F1    F2    F3     F4           date

                            1     ab    ff    gg    gggg    05/08/2004
                            2     ab    fh    ht    kkk     04/04/2004

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
sdlenter
Sent: Wednesday, April 18, 2007 4:42 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Dups and date - urgent

Urgent! Need help...
Using Dataset and Not proc SQL 'having min' function

I have sas dataset
F1   F2  F3   F4    date
ab   ff  gg     hg   20070505
ab   ff   gg    jj    20040701
ab  fh   ht    kkk   20040404
ab  ff    gg   gggg  20040508

I need to have a table with unique records , based on F1, F2, and F3
field ONLY and keeping one reccord with the earliest date among the dups

so the new table will be
F1   F2  F3   F4    date
ab  fh   ht    kkk   20040404
ab  ff    gg   gggg  20040508

thank you!


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect@principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.

While this communication may be used to promote or market a transaction
or an idea that is discussed in the publication, it is intended to provide
general information about the subject matter covered and is provided with
the understanding that The Principal is not rendering legal, accounting,
or tax advice. It is not a marketed opinion and may not be used to avoid
penalties under the Internal Revenue Code. You should consult with
appropriate counsel or other advisors on all matters pertaining to legal,
tax, or accounting obligations and requirements.