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 |
Are you sensitive to code walk-throughs peer review or QC review?
What are the implications?
1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.
What are the difference between the sas data step and sas procs?
Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?
5 Answers American Express, Barclays,
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
At compile time when a SAS data set is read, what items are created?
For what purpose(s) would use the RETURN statement?
What will calendar procedure do?
what is intially documentation for a sas programmer?
Describe the ways in which you can create macro variables? : sas-macro
describe the interaction table in sas di? : Sas-di