249-30: Merging versus Joining: Comparing the DATA Step ...

SUGI 30 Tutorials Paper 249-30. Merging vs. JOINING: Comparing the DATA Step with SQL. Malachy J. Foley University of North Carolina at Chapel Hill, NC. ABSTRACT. Which merges files better: the SAS DATA Step or SAS SQL? Traditionally, the only way to merge files in SAS was via the SAS DATA Step. Now SAS provides a Structured Query Language (SQL) facility which also merges files. This tutorial compares and contrasts these two merge facilities. It examines the pros and cons of each merge technique. It looks at DATA Step code to perform specific merges and then looks at the corresponding SQL. code to perform the same merges. INTRODUCTION. This tutorial is a SQL primer for the SAS user with some experience with SAS DATA Steps and the MERGE. statement, but little or no experience with SQL. It focuses on Merging or joining two data sets in any combination with either the DATA Step or SQL.

• The PROC SQL statement turns on the SQL facility. This facility remains on until it is turned off by a QUIT statement. Thus, you can summit multiple SQL procedure statements (queries/tasks) after PROC SQL and before QUIT. • Each SQL procedure statement is run automatically. You do not need to submit a RUN statement.

Loading..

Tags:

  Corps, Proc sql

Information

Related search queries