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 the difference between class statement and by statement in proc means?
What is the Program Data Vector (PDV) and What are its functions?
what are all the ways to define macro variable??
2 Answers GSK GlaxoSmithKline,
What is the difference between %put and symbolgen? : sas-macro
For what purpose would you use the RETAIN statement?
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 it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
How does the internal authentication work in sas? : sas-grid-administration
Describe what are the different levels of administrative users in sas? : sas-grid-administration
Mention few capabilities of sas framework.
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
which date functions advances a date time or date/time value by a given interval? : Sas programming