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 ?    4 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 1 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 ?    3 Yes 2 No

Post New Answer



More SAS Interview Questions

Name and describe three SAS functions that you have used, if any?

4 Answers   Accenture,


Which is the best training institute for SAS in Delhi. Please reply

12 Answers   HSBC, HCL,


What is the order of application for output data set options, input data set options and SAS statements?

0 Answers   Quintiles,


How to do user inputs and command line arguments in SAS? D&B

2 Answers   BoA, Quintiles,


What is the purpose of the trailing and How would you use them?

8 Answers  






Why is a STOP statement needed for the point=option on a SET statement?

2 Answers   Quintiles,


If money were no object, what would you like to do?

0 Answers   Oracle,


How would you code a merge that will keep only the observations that have matches from both sets.

5 Answers   Accenture, Bank Of America,


what are the differences between proc report and proc tabulate?

3 Answers  


what are different type of sas servers ? On which server does the sas code execute ?

4 Answers   TCS,


When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

7 Answers  


I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,






Categories