What is the difference between nodup and nodupkey options?

Answer Posted / sas d

NODUP - removes the duplicates. Here the key to remove the
duplicates is the entire record.

NODUPKEY - removes the duplicates. Here the key is the
variable(s) specified by the BY statement.

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many display types available in sas bi dashboard? : Sas-bi

646


Difference between sum function and using “+” operator?

606


what is sas metadata server? : Sas-di

595


what is transformation in sas data integration? : Sas-di

560


what is operational data and operational system? : Sas-di

637






Which command is used to perform sorting in sas program?

599


Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2098


Describe the function and utility of the most difficult SAS macro that you have written?

2027


If a variable contains only numbers, can it be a character data type?

616


why is sas data integration studio important? : Sas-di

563


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

549


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

684


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

595


What are the applications primarily used by business analyst? : Sas-bi

555


How to convert a numeric variable to a character variable?

634