what is the difference between SET and MERGE?
- 19 Answers
- 66416 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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;
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / sandhya
SET statement is used for one-to-one, concatination and
interleaving whereas MERGE is used for match merging.
| Is This Answer Correct ? | 4 Yes | 8 No |
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.
| Is This Answer Correct ? | 2 Yes | 7 No |
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.
| Is This Answer Correct ? | 3 Yes | 9 No |
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.
| Is This Answer Correct ? | 0 Yes | 6 No |
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.
| Is This Answer Correct ? | 3 Yes | 10 No |
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
| Is This Answer Correct ? | 14 Yes | 22 No |
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.
| Is This Answer Correct ? | 6 Yes | 14 No |
Answer / chandra sekar
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 | 30 No |
Tell e how how dealt with..
describe about metadata object? : Sas-di
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
how do the in= variables improve the capability of a merge? : Sas programming
What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.
2 Answers ABC, ASD Lab, CitiGroup,
What is the difference between one to one merge and match merge? Give an example.
What does the trace option do?
What statement do you code to tell SAS that it is to write to an external file?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
what is fact table and factless table?
What techniques and/or PROCs do you use for tables?
Teradata 
