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 is the role of unrestrictive users? : sas-grid-administration
What is a put statement?
what is data integration? : Sas-di
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What is the difference between using drop = data set option in data statement and set statement?
For what purposes have you used sas macros? : sas-macro
what are the categories that sas informats are used to the place the data? : Sas-administrator
Give e an example of..
Mention common programming errors committed in sas ?
Describe a time when you were really stuck on a problem and how you solved it?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
Explain what is data step?
Describe the function and untility of the most difficult SAS macro that you have written.
what is sas enterprise intelligence architecture? : Sas-bi