what is the difference between SET and MERGE?

Answer Posted / mallikarjuna reddy

set statement joins two datasets vertically, like set
operators in PROC SQL and proc append. merge statements
joins 2 datasets horizontally, like joins in PROC SQL.

Is This Answer Correct ?    34 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What Proc glm does?

607


What is the length assigned to the target variable by the scan function?

670


what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

1915


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

715


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2288






What do the put and input function do?

583


What is a pdv and what are its functions?

598


What is the command used to find missing values?

588


what are informats in sas? : Sas-administrator

581


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

694


how to read the variables in sas? : Sas-administrator

551


explain about various caches available in data integrator? : Sas-di

576


how can you create zero observation dataset? : Sas programming

631


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?

1159


How would you invoke a macro? : sas-macro

548