Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between DUPKEY and NODUPKEY???
- 4 Answers
- 23444 Views
- Cognizant, EXL, I also Faced
- E-Mail Answers
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 the purpose of _error_? : Sas programming
what is conditional processing?
how does sas handle missing values in an update? : Sas programming
What do you feel about hardcoding?
data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat
If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
What is the length assigned to the target variable by the scan function?
what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
what is SAS OPTIMIZATION?
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?
How do you generate random samples?
what is the difference between SET and MERGE?
Teradata 
