what is the difference between SET and MERGE?

Answer Posted / ashok kore

Set : Its append the datasets is dataset by dataset at row
level. It's not need to sort the datasets before append
datasets.

Merge : Its merge the datasets according to conditions at
column level. It needs sort datasets by variable before
merge the datasets. It works like joins in Proc sql.

Is This Answer Correct ?    6 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain about sas business intelligence? : Sas-bi

596


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

549


What are the differences between sum function and using “+” operator?

576


for whom is sas data integration studio designed? : Sas-di

556


How do you debug and test your SAS programs?

1046






What is the difference between one to one merge and match merge? Give an example.

571


If a variable contains only numbers, can it be a character data type?

612


What is the sas data set? : sas-grid-administration

571


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

636


what type of graphs we will create(for 2+years candidates)?

1903


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

569


what is star schema? : Sas-di

645


How necessary is it to be creative in your work?

2018


Which command is used to save logs in the external file?

566


How we can create SAS USER DEFINED CODE?

1609