:: 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                      
Categories >> Software >> Data Warehouse >> SAS


 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (851)
 Informatica interview questions  Informatica Interview Questions (1624)
 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 (172)
 Data Stage interview questions  Data Stage Interview Questions (564)
 SAS interview questions  SAS Interview Questions (556)
 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 (216)
what is the difference between SET and MERGE?
 Question Submitted By :: SAS
I also faced this Question!!     Answer Posted By  
# 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 ?    27 Yes 3 No
# 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 ?    21 Yes 5 No
Mallikarjuna Reddy
# 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
Is This Answer Correct ?    6 Yes 0 No
# 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
Is This Answer Correct ?    3 Yes 0 No
# 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
# 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
in concate and interleaving we use set option.

Horazentally-we use Merge option.
Is This Answer Correct ?    1 Yes 0 No
# 7
Answer 4 is the perfect one. 
Is This Answer Correct ?    0 Yes 0 No
Kumaraswamy Maduri
# 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
# 9
Set : only support data without relation, with relation i.e
by statement it will produce error if we right like merge
Ex :
Set statement
data demo;
set dm1;
set dm2;
It will produce the result same as merge , with or without

EX : data demo;
set dm1 dm2;

It will produce error.

Merge : it will combine the datasets with or without

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;

Merge (with relation)
data demo;
merge dm1 dm2;
by <variable name>
Is This Answer Correct ?    1 Yes 1 No
# 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

Other SAS Interview Questions
  Question Asked @ Answers
Please write codes to merge two datasets and keep every record in the first dataset.   1
/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;   4
What is the one statement to set the criteria of data that can be coded in any step? Accenture 4
How to get any kind of data in SAS? Is it possible to take data from notepad in SAS? GSK 7
how to import XTP files into SAS datasets? Barclays 1
Do you think professionally? Oracle 1
What statement do you code to write the record to the file?   5
i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one. CTS 6
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment. Cap-Gemini 2
how to delete the duplicate columns permanently in SQL Satyam 2
What r all the reporting procedures...?   3
How do you add a number to a macro variable?   3
For more SAS Interview Questions Click Here 

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