Transcription of MERGING vs. JOINING: Comparing the DATA Step with SQL
{{id}} {{{paragraph}}}
Example: confidence
MERGING vs. JOINING: Comparing the DATA Step with SQL
1 Paper 036-2009 MERGING vs. joining : Comparing the data step with SQLM alachy J. Foley, Chapel Hill, NCABSTRACT 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 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.
1 Paper 036-2009 MERGING vs. JOINING: Comparing the DATA Step with SQL Malachy J. Foley, Chapel Hill, NC ABSTRACT Which merges files better: the SAS DATA Step or SAS SQL?
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
SQL Tutorial, Oracle GoldenGate Hands-on Tutorial, Tutorial, Tutorial SQL, Structured Query Language, SUGI 23: Intermediate PROC SQL, Informix Guide to SQL: Syntax, Informix Guide to SQL Syntax, SQL Facts SQL stands for Structured Query Language, SQL Facts SQL stands for Structured Query Language SQL, 30: Merging versus Joining: Comparing the, SAS SQL