How would you delete observations with duplicate keys?
Answer Posted / thirumalesh
NoDupKey is to delete duplicate observations based on by variables as a key variable, Noduprecs is to delete multiple observations with same values(repeated values).
also it can be done using proc sql,
and using fist and last statements in if condiotion.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a macro routine?
How does the internal authentication work in sas? : sas-grid-administration
How can you limit the variables written to output dataset in data step?
What is the maximum and minimum length of macro variable
what is proc Index? and what is proc document?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
what do you mean by data staging area? : Sas-di
What are the default statistics for means procedure?
What is the length assigned to the target variable by the scan function?
what is the difference between nodup and nodupkey options? : Sas programming
Explain data step in SAS
How to create list output for cross-tabulations in proc freq?
What are the data types in sas?
how are numeric and character missing values represented internally? : Sas programming
What is factor analysis?