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 |
how do u test a pros sql(works or not) without executing it?
what are the types of interactive display types? : Sas-bi
Name validation tools used in SAS
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
Explain what is data step?
what is cummaltive frequency,and varience in proc unviarte
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
How do you put an elephant in the refrigerator?
hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?
Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
Explain translate function?