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 the primary data source for the wrs? : Sas-bi

1229


Are you involved in writing the inferential analysis plan? Tables specifications?

3949


What is SAS informats?

1100


what is hash files in sas and why we are using this one in sas?

2209


Do you know the features of sas?

1040


Explain the difference between informat and format with an example.

1162


which features do you use to check the data validations and errors? : Sas-administrator

1050


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

1014


If a variable contains letters or special characters, can it be numeric data type?

1208


what is the use of proc sql? : Sas programming

1131


What are the parameters of scan function?

1169


what are sas bi dashboard components? : Sas-bi

1167


explain what is data set in sas? : Sas-administrator

984


what is sas business intelligence? : Sas-bi

1173


What are the 3 components in sas programming?

1190