What is the difference between nodup and nodupkey options?
Answer Posted / madhupamuluri
Nodup or noduprec: It deletes duplicate observations (the observation repeated more than one time in a dataset) by using all the variables which are available in the input statement.
Nodupkey: It deletes duplicate data values(the value is repeated more than one time in a variable)as well as duplicate observations (the observation repeated more than one time in a dataset) by using the key variable which are available in the by statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you know about sas data set?
how many types prompting framework can be broken down to? : Sas-bi
how would you determine the number of missing or nonmissing values in computations? : Sas programming
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
what are input dataset and output dataset options? : Sas programming
Explain why double trailing @@ is used in input statement?
What can be the size of largest dataset in SAS?
Tell me about % include and % eval? : sas-macro
What is the basic syntax style in SAS?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
How to convert a numeric variable to a character variable?
Give an example where SAS fails to convert character value to numeric value automatically?
What is the maximum length of the macro variable?
What are the implications?
Mention the difference between ceil and floor functions in sas?