By admin | December 16, 2009

SAS Certified Adv Programmer 130 Questions (33)

Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

A. NODUP
B. UNIQUE
C. DISTINCT
D. NODUPKEY

13 comments | Add One

  1. admin - 12/16/2009 at 10:13 am

    A

  2. rf - 03/6/2011 at 11:47 pm

    there is no such thing as NODUP in SQL

  3. sass - 05/9/2011 at 11:34 am

    D: removing duplicates is the NODUPKEY option of PROC SORT

  4. SAS_Prer - 10/22/2011 at 12:57 pm

    D: NOdupkey is the correct ans.

  5. Viv - 01/28/2012 at 6:54 pm

    NODUP is an alias for NODUPRECS.

  6. Jagadeesh - 03/27/2012 at 12:43 am

    This is a tricky question.
    NODUP eliminates the duplicates but not with PROC SORT. Coz NODUPKEY eliminates duplicates when using with BY Variable. So as PROC SORT uses by variable the correct answer would be D. NODUPKEY.
    @rf.. Yes theres is no NODUP in sql. But in SQL we will use DISTINCT option to eliminate duplicates.

  7. SSK22 - 04/24/2012 at 10:24 am

    Correct andwer is A. NODUP is an alias for NODUPRECS. It is a SAS option, not SQL. NODUP removes only consecutive observations, question was about this. NODUPKEY is deleting based on a BY variable.

  8. monica - 05/31/2012 at 4:10 am

    A is the answer. NODUP is an alias for NODUPRECS

  9. Polina - 08/15/2012 at 10:50 am

    A. (NODUP is short from NODUPRECS)

  10. rob roy - 09/3/2012 at 5:28 am

    NODUPKEY is the answer

  11. Kamal KC - 09/18/2012 at 12:12 am

    ANS:- A
    Please try to understand the difference betwen NODUP and NODUPKEY,i.e.
    The NODUP option checks for and eliminates duplicate observations.

    The NODUPKEY option checks for and eliminates duplicate observations by variable values.

  12. sanj - 11/26/2012 at 11:10 am

    A is correct. NODUP is a valid option in SAS which is an alias for NODUPRECS. NODUPKEY considers only the duplicate ‘key’ or By variable values for elimination, not the entire observation.

  13. Consty - 02/20/2013 at 11:50 pm

    A:The NODUP option causes PROC SORT to compare all variable values for each observation to the previous one written to the output data set. The NODUPKEY option causes PROC SORT to compare all BY values for each observation to those for the previous observation written to the output data set

Leave a Comment

Leave a Reply

Your email address will not be published. Required fields are marked *