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
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
Explain the difference between nodup and nodupkey options?
How would you identify a macro variable? : sas-macro
What do you know about sas data set?
What is interleaving in SAS?
Where do you use proc means over proc freq?
what is the primary data source for the wrs? : Sas-bi
How will you generate test data with no input data?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
how are numeric and character missing values represented internally? : Sas programming
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
how will you locate the sas platform applications? : Sas-bi
Describe what are the different levels of administrative users in sas? : sas-grid-administration
Difference between informat and format?
what is program data vector? : Sas-administrator