Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between nodup and nodupkey options?
- 20 Answers
- 80583 Views
- iFlex, Makro, Talwar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhupamuluri
Nodup or noduprec: It deletes duplicate observations (the observation repeated more than one time in a dataset) by using all the variables which are available in the input statement.
Nodupkey: It deletes duplicate data values(the value is repeated more than one time in a variable)as well as duplicate observations (the observation repeated more than one time in a dataset) by using the key variable which are available in the by statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ajay
nodupkey deletes all the observations irrespective of the
other values in other variables if the by varaible provided
is repeating
nodup deletes only the observations that are common in the
provided by variables if all the other observations in it
are same.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / balanarasimhudu
Nodupkey: Checks observation based on the KEY variables.
Noduprecs(or) Nodup: Checks all variables,not just KEY variables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pratik
Nodup option is used to delete the observation if all the
varaibles are same with other observation.
Nodup key is used to delete the observation based on key
value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / surendar
NODUP:- It eliminates or removes if the same information available multiple times in all variables
(It works on all variables).
NODUPKEY:-It eliminates or removes if the same information available multiple times with in the variable.
(It Works on only one key variable)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ravi
nodup delete the duplicate observations by considering the entire record..if the entire record is a duplicate one.
nodupkey deletes the duplicates by considering the by varaibles.
nodup compares all the variables in the dataset and nodupkey compares only just by variables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / t.n.v.srinivas
Nodup: use with the nodup we can remove the duplicate
observations
Nodupkey:use with the nodupkey we can remove the duplicate
values
| Is This Answer Correct ? | 5 Yes | 8 No |
Answer / san
NODUP option eliminates the duplicate observations.
NODUPKEY eliminates the duplicate observation keys in the
data set.
| Is This Answer Correct ? | 19 Yes | 27 No |
Answer / venu
NODUP option eliminates the duplicate observations.
NODUPKEY eliminates the duplicate data values in the
data set.
| Is This Answer Correct ? | 12 Yes | 27 No |
Answer / raghu
nodup and nodupkey both are used for eliminate the duplicate
observations in data set.
| Is This Answer Correct ? | 3 Yes | 21 No |
what are all the ways to define macro variable??
2 Answers GSK GlaxoSmithKline,
What makes sas stand out to be the best over other data analytics tools?
Does anybody has lastest SAS certification dumps,if anybody has please mail me at akshara_SAS@ymail.com Thanks Akshara
What does a PROC TRANSPOSE do?
how we can call macros with in data step?
For what purposes have you used sas macros? : sas-macro
Briefly describe 5 ways to do a "table lookup" in sas.
how will you locate the sas platform applications? : Sas-bi
what is the need of INDEX in datasets?
What is the difference between SAS Data step and SAS PROC SQL, and which is better?
what is sas data set?
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
Teradata 
