ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data Warehouse >> SAS
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (178)
 Business Objects interview questions  Business Objects Interview Questions (750)
 Cognos interview questions  Cognos Interview Questions (836)
 Informatica interview questions  Informatica Interview Questions (1617)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (168)
 Data Stage interview questions  Data Stage Interview Questions (562)
 SAS interview questions  SAS Interview Questions (549)
 Micro Strategy interview questions  Micro Strategy Interview Questions (35)
 ETL interview questions  ETL Interview Questions (193)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (214)
Question
What is the difference between nodup and nodupkey options?
 Question Submitted By :: Rajaanku11
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the difference between nodup and nodupkey options?
Answer
# 1
The NODUP option checks for and eliminates duplicate
observations.

The NODUPKEY option checks for and eliminates duplicate
observations by variable values.
 
Is This Answer Correct ?    71 Yes 10 No
Asha
 
  Re: What is the difference between nodup and nodupkey options?
Answer
# 2
NODUP option eliminates the duplicate observations.


NODUPKEY eliminates the duplicate observation keys in the
data set.
 
Is This Answer Correct ?    18 Yes 27 No
San
 
 
 
  Re: What is the difference between nodup and nodupkey options?
Answer
# 3
NODUP option eliminates the duplicate observations.


NODUPKEY eliminates the duplicate data values in the
data set.
 
Is This Answer Correct ?    12 Yes 25 No
Venu
 
  Re: What is the difference between nodup and nodupkey options?
Answer
# 4
nodup:
By using the proc sort procedure along with nodup
option ,it checks for and eliminates the duplicate records.

nodupkey:
NODUPKEY eliminates the duplicate observation keys
in the data set.
 
Is This Answer Correct ?    16 Yes 13 No
Chiranjeevi
 
  Re: What is the difference between nodup and nodupkey options?
Answer
# 5
NODUPKEY :

It checks similar BY variable values and deletes duplicate
observations in the data set based on BY variable values...

NODUP :

It will be available with latest version, It checks and
deletes duplicate observations in the dataset.....

Any comments plzz...
 
Is This Answer Correct ?    11 Yes 10 No
Chandu
 
  Re: What is the difference between nodup and nodupkey options?
Answer
# 6
nodup and nodupkey both are used for eliminate the duplicate
observations in data set.
 
Is This Answer Correct ?    3 Yes 20 No
Raghu
 
  Re: What is the difference between nodup and nodupkey options?
Answer
# 7
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 ?    4 Yes 8 No
T.n.v.srinivas
 
  Re: What is the difference between nodup and nodupkey options?
Answer
# 8
The Nodup: can only remove the duplicate next to each other.
The by variables are very important for remove
the duplicates which all the variables have the same value.

The nodupkey: will remove the duplicated when they have the
same values for the by variables
 
Is This Answer Correct ?    27 Yes 1 No
Stopby
 
  Re: What is the difference between nodup and nodupkey options?
Answer
# 9
Nodup : it delete the observartions based on each and every
variable value is same irespective of sorting varibale.

Nodupkey: It delete the observarions based on sorting
variable.
 
Is This Answer Correct ?    9 Yes 3 No
Pavan
 
  Re: What is the difference between nodup and nodupkey options?
Answer
# 10
Nodup:
It deletes those observations if every variable in the
dataset has the same value

Nodupkey:
It deletes all the observation on sorting variable. It
retains the first variable and deletes all other coming
after that
 
Is This Answer Correct ?    12 Yes 3 No
Tariq Sharjil
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
How experienced are you with customized reporting and use of Data _Null_ features? Oracle 4
what is cummaltive frequency,and varience in proc unviarte L&T 1
HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL? Accenture 3
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didnít have a value? Accenture 3
How we will Developing new reports Using Data step programming and Macros ?   4
how to remove the duplicates by proc sql? Genpact 2
What is the purpose of using the N=PS option? Oracle 2
wt is a-z and a--z? Accenture 3
which domain is better in sas? clinical trails or banking   3
how do you derive descriptive statistics? Accenture 1
In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable) GSK-GlaxoSmithKline 8
how do you read binary data in sas? Satyam 3
 
For more SAS Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright © 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com