what is the difference between SET and MERGE?
Answer Posted / 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 |
Post New Answer View All Answers
what is the primary data source for the wrs? : Sas-bi
Are you involved in writing the inferential analysis plan? Tables specifications?
What is SAS informats?
what is hash files in sas and why we are using this one in sas?
Do you know the features of sas?
Explain the difference between informat and format with an example.
which features do you use to check the data validations and errors? : Sas-administrator
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
If a variable contains letters or special characters, can it be numeric data type?
what is the use of proc sql? : Sas programming
What are the parameters of scan function?
what are sas bi dashboard components? : Sas-bi
explain what is data set in sas? : Sas-administrator
what is sas business intelligence? : Sas-bi
What are the 3 components in sas programming?