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 versions of SAS have you used (on which platforms)?
Explain translate function?
how we can call macros with in data step?
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
Explain data_null_?
What are the default statistics that proc means produce?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
code the tables statement for a single level frequency?
What is difference between N and n????
What was the last computer book you purchased? Why?
what is the use of catalog?
how can get the first and last observations in a dataset using Proc SQl?