What is the difference between nodup and nodupkey options?

Answer Posted / stopby

The Nodup: can only remove the duplicate next to each other.
The by variables are very important for remove
the duplicates which all the variables have the same value.

The nodupkey: will remove the duplicated when they have the
same values for the by variables

Is This Answer Correct ?    43 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Compare sas with other data analytics tools.

575


How many data types are there in SAS?

624


What are the parameters of scan function?

612


what is snowflake schema? : Sas-di

686


Are you sensitive to code walk-throughs peer review or QC review?

2593






explain the difference between proc means and proc summary?

661


where to use sas business intelligence? : Sas-bi

574


how does sas handle missing values in formats? : Sas programming

572


If a variable contains letters or special characters, can it be numeric data type?

755


Explain proc sort?

659


If you could design your ideal job, what would it look like?

2364


What do the put and input function do?

581


describe the interaction table in sas di? : Sas-di

584


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1219


What is the basic structure of a sas program?

589