what is the difference between DUPKEY and NODUPKEY???
Answers were Sorted based on User's Feedback
Answer / sandhya
dupkey-to place duplicate keys
nodupkey -To delete duplicate keys
| Is This Answer Correct ? | 15 Yes | 1 No |
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 |
Answer / naveenkumar
Dupkey eliminates duplicate observations using all of the
variables given in input statement.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / naveenkumar
Nodupkey eliminates duplicate observations using the
variables which we pass at by statement
| Is This Answer Correct ? | 4 Yes | 2 No |
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
What are the differences between sum function and using “+” operator?
How could you generate test data with no input data?
Explain how you can debug and test your SAS program?
how do you validate sas program?
what has been your most common programming mistake? : Sas programming
Briefly describe 5 ways to do a "table lookup" in sas.
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE
Why do we use QUIT commmand for proc datasets and proc sql ???
what are _numeric_ and _character_ and what do they do? : Sas programming
What is the difference between %local and %global?
how many display types available in sas bi dashboard? : Sas-bi