:: 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 (853)
 Informatica interview questions  Informatica Interview Questions (1626)
 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 (557)
 Micro Strategy interview questions  Micro Strategy Interview Questions (37)
 ETL interview questions  ETL Interview Questions (196)
 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 ?    28 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 ?    22 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 ?    7 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 ?    4 Yes 0 No
# 5
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 ?    2 Yes 0 No
# 6
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
# 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
what is the use of proc sql? CitiGroup 5
· What are some good SAS programming practices for processing very large data sets?   6
Can anyone help to find a statement to get all the predefined formats? Verinon-Technology-Solutions 3
How do you put an elephant in the refrigerator? Oracle 6
sas implimented companies in hyderabad CTS 11
how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset? TCS 7
what is the formula to measure Baseline   3
How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?   2
what is chi-square test? have you used that? Accenture 1
How would you determine how far down on a page you have printed in order to print out footnotes?   3
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?   3
what is p-value Accenture 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.   ::