Answer / sweety

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;

Answer / sandhya

SET statement is used for one-to-one, concatination and
interleaving whereas MERGE is used for match merging.

Answer / pari

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.

Answer / kiran kumar yarlagadda

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.

Answer / srinivas,korasavada

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.

Answer / chiranjeevi

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.

Answer / kishore

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

Answer / ashok kore

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.

Answer / chandra sekar

Set statement is usually used to "append" to two datasets.
And merge step is used to "Merge" two datasets.

How do you read in the variables that you need?

9 Answers   Accenture,

how do you read binary data in sas?

3 Answers   Satyam,

what are the validation tools in sas?

3 Answers   TCS,

when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.

1 Answers  

how to change the execute of macro

0 Answers   Mind Tree,

how to display duplicated observations in a data using base sas.

13 Answers   HCL, TCS,

What are the difference between ceil and floor functions in sas?

0 Answers  

WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS FUNCTION?

3 Answers   IBM, Zensar,

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?

2 Answers  

what is washout period?

3 Answers   Cognizant,

what is sas and what are the functions? : Sas-administrator

0 Answers  

We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?

5 Answers