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

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

736


how to do user inputs and command line arguments in sas?

2417


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

527


What is the difference between INPUT and INFILE ?

747


What are the scrubbing procedures in sas?

561






How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

1870


do you need to know if there are any missing values? : Sas programming

540


describe about physical data integration? : Sas-di

551


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

639


what are the categories that sas informats are used to the place the data? : Sas-administrator

605


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1156


What is a method to debug and test your SAS program?

703


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

621


What are the uses of sas?

692


what is SAS OPTIMIZATION?

1808