what is the difference between SET and MERGE?

Answer Posted / swetha

We use merge when we have information abouth the topic in
two or more datasets. So that by merging we get the
complete information about the topic in one dataset.It is
combining the data horizontally.

But we use set, when the datasets are mutually exclusive.
i.e. information in dataset A in not depending the
information in dataset B.It is combining the data
vertically.

Is This Answer Correct ?    24 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you limit the variables written to output dataset in data step?

757


what is hierarchy flattening? : Sas-di

625


Enlist the functions performed by sas.

681


How to convert a numeric variable to a character variable?

634


what is the basic structure sas administrator? : Sas-administrator

569






how will you locate the sas platform applications? : Sas-bi

587


How long can a macro variable be? A token? : sas-macro

724


Explain proc sort?

673


Give some ways by which you can define the variables to produce the summary report (using proc report)?

604


Explain the special input delimiters used in sas programming.

589


What is the use of PROC gplot?

642


how do the in= variables improve the capability of a merge? : Sas programming

945


Differentiate between proc means and proc summary.

611


What is the use of function Proc summary?

659


Can you execute macro within another macro? : sas-macro

532