diff between nodup rec and ondup key???
Answers were Sorted based on User's Feedback
Answer / mallikarjuna
nodupkey deletes duplicate observations based on by
variable.
noduprec delete the duplicate observations if entire
observation is duplicate.
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / ramkgupta
simply to say nodup and noduprec checks values present in all variables in dataset from one record to next record where as nodupkey checks values present in only variables given in by statement not all variables in a dataset.
Is This Answer Correct ? | 5 Yes | 0 No |
How would you code a merge that will keep only the observations that have matches from both sets.
5 Answers Accenture, Bank Of America,
There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?
How are the analysis data sets structured?
What are the prime responsibilities of data integration administrator? : Sas-di
What is the difference between %local and %global? : sas-macro
Can you suggest us materials for sdtm mapping?
What is the difference Using & and && in the macro variables
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
Mention some common errors that are usually committed in sas programming.
how we can create optional or required parameters in SAS macro...
IS SAS COMPILER OR INTERPRETER? EXPLAIN?
3 Answers Aon Hewitt, HSBC, SCL, TCS,
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?