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 are _numeric_ and _character_ and what do they do? : Sas programming
How is character variable converted into numeric variable and vice versa?
how to remove duplicates using proc sql?
how do you validate sas program?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
Describe a time when you were really stuck on a problem and how you solved it?
Explain data_null_?
what is the difference between sas and other datawarehousing languages?what are the advantages of sas over them?
There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.
i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?
What r all the reporting procedures...?
What are all the problems you faced while validating tables and reports?
0 Answers Accenture, Quintiles,