what is the difference between DUPKEY and NODUPKEY???

Answers were Sorted based on User's Feedback



what is the difference between DUPKEY and NODUPKEY???..

Answer / sandhya

dupkey-to place duplicate keys
nodupkey -To delete duplicate keys

Is This Answer Correct ?    15 Yes 1 No

what is the difference between DUPKEY and NODUPKEY???..

Answer / rauthu

NODUP (NODUPREC): Eliminates all CONSECUTIVE duplicates by comparing all variables.

NODUPKEY: Eliminates all CONSECUTIVE duplicates by comparing by variables ONLY.(*** clue KEY = BY )

Is This Answer Correct ?    5 Yes 0 No

what is the difference between DUPKEY and NODUPKEY???..

Answer / naveenkumar

Dupkey eliminates duplicate observations using all of the
variables given in input statement.

Is This Answer Correct ?    4 Yes 2 No

what is the difference between DUPKEY and NODUPKEY???..

Answer / naveenkumar

Nodupkey eliminates duplicate observations using the
variables which we pass at by statement

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More SAS Interview Questions

What is the difference between class statement and by statement in proc means?

0 Answers  


What is the Program Data Vector (PDV) and What are its functions?

9 Answers  


what are all the ways to define macro variable??

2 Answers   GSK GlaxoSmithKline,


What is the difference between %put and symbolgen? : sas-macro

0 Answers  


For what purpose would you use the RETAIN statement?

0 Answers   Quintiles,






There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT

8 Answers   D&B,


How does the internal authentication work in sas? : sas-grid-administration

0 Answers  


Describe what are the different levels of administrative users in sas? : sas-grid-administration

0 Answers  


Mention few capabilities of sas framework.

0 Answers  


hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

0 Answers   Cognizant,


We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B

3 Answers  


which date functions advances a date time or date/time value by a given interval? : Sas programming

0 Answers  


Categories