Date:         Wed, 28 Jun 2006 18:57:57 -0500
Reply-To:     SAS_learner <proccontents@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_learner <proccontents@GMAIL.COM>
Subject:      what is difference UNIQUE and DISTINCT and NODUPS and NODUPKEY
              .......................
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hello guys

I am going  through SAS -SQL manual and I found two different Key words

select distinct mannum ;
    from table ;
quit;

 select UNIQUE  mannum ;
    from table ;
quit;

are they are same if they are different what is equalvant function in SAS .
I know distinct is same as nodupkey in proc sort ( by the way when I talking
about nodupkey is there any difference between nodups and nodupkey  and
nodup ) I looked online doc but I did not understand the difference can any
one explain me thanks

Thanks for Ur time