Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between SET and MERGE?
- 19 Answers
- 72104 Views
- CitiGroup, I also Faced
- E-Mail Answers
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
Explain bmdp procedure?
what is proc Index? and what is proc document?
how to remove duplicates using proc sql?
what other sas products have you used and consider yourself proficient in using? : Sas programming
what is enterprise guide? What is the use of it? : Sas programming
Hi, If anyone has base SAS certification dumps, please share.
What do you know about symput and symget?
Name any two sas spawners? : sas-grid-administration
Explain why double trailing @@ is used in input statement?
what is data access? : Sas-di
Differentiate between format and informat? : sas-grid-administration
how does sas handle missing values in assignment statements? : Sas programming
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
What do you know about sas data set?
Give an example where SAS fails to convert character value to numeric value automatically?
