what is difference UNIQUE and DISTINCT and NODUPS and NODUPKEY

Discussion in 'SAS (Statistical Analysis Software)' started by SAS_learner, Jun 29, 2006.

  1. SAS_learner

    SAS_learner Guest

    Hello guys

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

    select distinct mannum ;
    from table ;

    select UNIQUE mannum ;
    from table ;

    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
    SAS_learner, Jun 29, 2006
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.