TU21
MERGING: Comparing the Data Step with SQL
Invited
Malachy J. Foley
University of North Carolina at Chapel Hill
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.
Biography:
Mal Foley started programming computers in high school and never stopped. His career includes being an international computing consultant, a university professor, a computing department manager, and CEO of a computing company. Mal's specialties are clinica
l trials, survey research, business applications development, and database management. He has consulted to IBM, Dow Chemical, Ford-Rockefeller Foundation, Department of Agriculture, Agency for International Development, universities, and the United Nations
. He gives seminars and presentations at many SAS users' groups.