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 is AE onset date and what is RDS?
What’s the difference between var b1 – b3 and var b1 — b3?
What is SAS informats?
which date functions advances a date time or date/time value by a given interval? : Sas programming
what is sas olap server? : Sas-di
what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.
what is sas and what are the functions? : Sas-administrator
What is difference between N and n????
what are the categories that sas informats are used to the place the data? : Sas-administrator
You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
how we can call macros with in data step?