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 |
Explain how you can debug and test your SAS program?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
Are you involved in writing the inferential analysis plan? Tables specifications?
How can you put a "trace" in your program?
what are sas/access and sas/connect? : Sas programming
What does a PROC TRANSPOSE do?
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
how many display types available in sas bi dashboard? : Sas-bi
What is the difference between using drop = data set option in data statement and set statement?
how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too