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 SET and MERGE?
 Question Submitted By :: Akshara
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the difference between SET and MERGE?
Answer
# 1
Set statement is usually used to "append" to two datasets.
And merge step is used to "Merge" two datasets.
 
Is This Answer Correct ?    12 Yes 29 No
Chandra Sekar
 
  Re: what is the difference between SET and MERGE?
Answer
# 2
set statement is used to create a new data set using
existing data set sothat we can add new variables ,create
subset
merge statement when we want to match the observation of
one dataset with observation of other dataset
 
Is This Answer Correct ?    14 Yes 22 No
Kishore
 
 
 
  Re: what is the difference between SET and MERGE?
Answer
# 3
Set : Its append the datasets is dataset by dataset at row
level. It's not need to sort the datasets before append
datasets.

Merge : Its merge the datasets according to conditions at
column level. It needs sort datasets by variable before
merge the datasets. It works like joins in Proc sql.
 
Is This Answer Correct ?    6 Yes 14 No
Ashok Kore
 
  Re: what is the difference between SET and MERGE?
Answer
# 4
set statement joins two datasets vertically, like set
operators in PROC SQL and proc append. merge statements
joins 2 datasets horizontally, like joins in PROC SQL.
 
Is This Answer Correct ?    18 Yes 5 No
Mallikarjuna Reddy
 
  Re: what is the difference between SET and MERGE?
Answer
# 5
the difference between set and merge is
set concatenates the data sets where as merge matches the
observations of the data sets.
 
Is This Answer Correct ?    26 Yes 3 No
Lavanya
 
  Re: what is the difference between SET and MERGE?
Answer
# 6
MERGE:Merge statement is used to combine two datasets,The
two datasets can be combined by matching variable should by
specify by using statement calld 'by' in the data step.


SET:SET statement concatenates the two data sets by matching
variable.

Difference:when ever we are using the merge statement it
will over writes the existing and the similar observations
across two datasets,But where as the set statement doesn't
overwrites it.
 
Is This Answer Correct ?    2 Yes 10 No
Chiranjeevi
 
  Re: what is the difference between SET and MERGE?
Answer
# 7
what is the difference between SET and MERGE?
ans:
set statement is used to create a new dataset by using
already existing datasetname/and this statement is used to
concotinate the number of datasets.whenever we are using
set statment it will be added as obsevation by obsevation
level where as when we use merge it will be added as
variable by variable level.
 
Is This Answer Correct ?    3 Yes 8 No
Kiran Kumar Yarlagadda
 
  Re: what is the difference between SET and MERGE?
Answer
# 8
set concatinate the data set and of the another data
set.The second dataset starts end of the last value onwards.
merge:It adds sas files one dataset to end of the another
dataset.
 
Is This Answer Correct ?    0 Yes 6 No
Srinivas,korasavada
 
  Re: what is the difference between SET and MERGE?
Answer
# 9
SET statement is used for one-to-one, concatination and
interleaving whereas MERGE is used for match merging.
 
Is This Answer Correct ?    3 Yes 8 No
Sandhya
 
  Re: what is the difference between SET and MERGE?
Answer
# 10
Set and merge statement perform similar function, in case
of set statement, the two data sets are merged under
unconditional criteria, but while using merge, it works
under conditional criteria by applying the PROC SORT
procedure ., i.e., by statement used.
 
Is This Answer Correct ?    2 Yes 6 No
Pari
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
what is the diff b/w verification validation in sas SAS 3
There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it? Oracle 1
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?   3
How experienced are you with customized reporting and use of Data _Null_ features? Oracle 4
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?   1
how to know the attributes of first five datasets in a library   2
what other SAS features do you use for error trapping and data validation?   3
What is the one statement to set the criteria of data that can be coded in any step? Accenture 4
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?   16
What is the difference between Regression and Logistic Regression? Can u explain the Assumptions/Conditions?   3
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?   1
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition? Oracle 2
 
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