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

explain the concepts and capabilities of business object? : Sas-bi

0 Answers  


How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values?

2 Answers   BoA,


How to create a permanent sas data set?

0 Answers  


How we will Developing new reports Using Data step programming and Macros ?

4 Answers  


Difference Between Scan and Substr

2 Answers  






how do you pull data from equifax?tell me the process?

0 Answers   Synchrony Financial,


what is the difference between proc means and proc tabulate?

3 Answers   Cognizant, CTS,


How would you determine how far down on a page you have printed in order to print out footnotes?

3 Answers  


What are the difficulties u faced while doing vital signs table or dataset?

0 Answers  


Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS

1 Answers   Accenture, HSBC,


what is the difference between unique key and primary key? : Sas-di

0 Answers  


What are the functions used for character handling?

0 Answers  


Categories