what is the difference between SET and MERGE?

Answer Posted / pratik

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
append.
in concate and interleaving we use set option.

Horazentally-we use Merge option.

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

1679


please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

1661


What is the maximum length of the macro variable? : sas-macro

616


What can you learn from the SAS log when debugging?

915


explain about sas business intelligence? : Sas-bi

596






How sas treats the dsd delimiters?

716


what are _numeric_ and _character_ and what do they do? : Sas programming

672


What will calendar procedure do?

593


Define run-group processing?

579


what is the effect of the options statement errors=1? : Sas programming

588


WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2262


What are the uses of sas?

700


What is the work of tranwrd function?

662


What does PROC print, and PROC contents do?

722


In proc transpose and data step with arrays which one you pick?

2572