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 (183)
 Business Objects interview questions  Business Objects Interview Questions (751)
 Cognos interview questions  Cognos Interview Questions (842)
 Informatica interview questions  Informatica Interview Questions (1622)
 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 (563)
 SAS interview questions  SAS Interview Questions (550)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (215)
Question
what is the difference between SET and MERGE?
 Question Submitted By :: SAS
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
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
 
Answer
# 2
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 ?    20 Yes 5 No
Mallikarjuna Reddy
 
 
 
Answer
# 3
We use merge when we have information abouth the topic in
two or more datasets. So that by merging we get the
complete information about the topic in one dataset.It is
combining the data horizontally.

But we use set, when the datasets are mutually exclusive.
i.e. information in dataset A in not depending the
information in dataset B.It is combining the data
vertically.
 
Is This Answer Correct ?    5 Yes 0 No
Swetha
 
Answer
# 4
Set: Arrange the data one by one
merge: Arrange the data side by side
ex: set merge
id name age id name age
1 1 a 23
a
23
 
Is This Answer Correct ?    3 Yes 0 No
Ram
 
Answer
# 5
Practically adding different information to same records is
known as merging. While Adding same information to new
records is known as set.
 
Is This Answer Correct ?    1 Yes 0 No
Pricil Kurian
 
Answer
# 6
Set statments are used to copy the data from existing
database to new database.

where merge is used to join two dataset and both should
have common varaible and same number of observation.

IN mearging we have two type one is

Vertically-we have three process concate,interleaving and
append.
in concate and interleaving we use set option.

Horazentally-we use Merge option.
 
Is This Answer Correct ?    1 Yes 0 No
Pratik
 
Answer
# 7
Answer 4 is the perfect one. 
Is This Answer Correct ?    0 Yes 0 No
Kumaraswamy Maduri
 
Answer
# 8
Methods of Combining Sas Datasets: Concatenation(set statment), Merge Statement:

Concatenating combines two or more SAS data sets, one after the other, into a single SAS data set.
- Use the SET statement in a DATA step to concatenate SAS data sets.
- Any number of SAS data sets can be read with a single SET statement.


Merging combines observations from two or more SAS data sets into a single observation in a new data set.
 
Is This Answer Correct ?    0 Yes 0 No
Ram
 
Answer
# 9
Set : only support data without relation, with relation i.e
by statement it will produce error if we right like merge
statement.
Ex :
Set statement
data demo;
set dm1;
set dm2;
run;
It will produce the result same as merge , with or without
relation.

EX : data demo;
set dm1 dm2;
run;

It will produce error.

Merge : it will combine the datasets with or without
relation.

The only difference is set is not more efficient to combine
the datasets as we need to write set statement everytime.
Ex :

Merge (without relation)
data demo;
merge dm1 dm2;
run;

Merge (with relation)
data demo;
merge dm1 dm2;
by <variable name>
run;
 
Is This Answer Correct ?    1 Yes 1 No
Sweety
 
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
 
how do u validate sas program Accenture 3
how to intersect the tables by using PROC MIXED? CitiGroup 1
What is difference between (a-z) and (a--z) Accenture 6
Name and describe three SAS functions that you have used, if any? Accenture 4
What other SAS features do you use for error trapping and data validation?   2
how to read character value without using substr function in sas ?   3
Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.   3
What is the difference between an informat and a format. Name three informats or formats.   6
How to read multiple excel sheets from a single excel file at once???? Verinon-Technology-Solutions 6
how to import HTML files into SAS datasets? HP 2
what is in stream data in SAS?   1
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If? Cognizent 4
 
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