Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is interleaving in SAS?

1114


How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1674


how can you import .csv file in to sas? : Sas programming

1099


for report generation which one you used proc report or data_null_?

7792


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

1060


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

1005


What is the use of divide function?

1067


In sas, what are the areas that you are most interested in? : sas-grid-administration

1074


What is program data vector (pdv) and what are its functions?

1250


why is sas considered self-documenting? : Sas programming

1146


What are the difference between sas functions and procedures?

1155


Mention how to limit decimal places for the variable using proc means?

1119


Which function is used to count the number of intervals between two sas dates?

1132


how to debug and test the sas program? : Sas-administrator

1038


Can you suggest us materials for sdtm mapping?

4448