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

which stats created by proc means that are not created by proc summary or vice versa?

2 Answers   GSK,


What does a PROC TRANSPOSE do?

8 Answers   Accenture,


What is difference between (a-z) and (a--z)

8 Answers   Accenture,


How would you remove a format that has been permanently associated with a variable? ________________

5 Answers   TCS, Quintiles,


In which case u go for libname and in which case u go for proc sql pass thru facilit diff?

1 Answers  






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  


what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';

3 Answers   HSBC,


Difference b/n proc means and proc summary procedures?

3 Answers   Accenture,


Do you think professionally?

1 Answers   Oracle,


what is hash files in sas and why we are using this one in sas?

0 Answers   SAS, L&T,


What does the RUN statement do?

0 Answers   Quintiles,


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?

2 Answers   Accenture,






Categories