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

What is the order of evaluation of the comparison operators: + - * /** ()?

3 Answers   Quintiles,


what the use of proc glm

1 Answers   Accenture, C Marc,


how do you read binary data in sas?

3 Answers   Satyam,


WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

0 Answers   Satyam,


What is the difference between Proc tabulate and Proc print

4 Answers   CitiGroup,






What are the functions done while Compilation...?

1 Answers   TCS,


Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated

1 Answers  


what is TAB delimiter? explain about it? what will you do to get TAB delimiter?

3 Answers   Cap Gemini,


How are numeric and character missing values represented internally?

0 Answers   Quintiles,


How would you include common or reuse code to be processed along with your statements?

3 Answers   Accenture,


Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

3 Answers  


what is intially documentation in sas?

1 Answers   Accenture,






Categories