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


Please Help Members By Posting Answers For Below Questions

What is the role of unrestrictive users? : sas-grid-administration

659


What is a put statement?

777


what is data integration? : Sas-di

728


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

752


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1000






What is the difference between using drop = data set option in data statement and set statement?

752


For what purposes have you used sas macros? : sas-macro

611


what are the categories that sas informats are used to the place the data? : Sas-administrator

710


Give e an example of..

1974


Mention common programming errors committed in sas ?

722


Describe a time when you were really stuck on a problem and how you solved it?

2287


how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

704


Explain what is data step?

814


Describe the function and untility of the most difficult SAS macro that you have written.

1813


what is sas enterprise intelligence architecture? : Sas-bi

639