Knowledge and Data Management White Papers
MERGING Vs. JOINING: Comparing the DATA Step With SQL
Overview 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 paper 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.
| Publisher | SAS Institute | File Format | |
|---|---|---|---|
| Date Published | March 2009 | ||
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 1 out of 2 users found this white paper useful
White Paper RSSAccelerating Enterprise Data Governance Part 1
DownloadIn the first of this series of three white papers, Mike Ferguson of Intelligent Business Strategies defines what data governance is and then looks at the requirements that need to...
Data Governance for Master Data Management and Beyond
There is growing interest on behalf of both data management professionals and senior business managers to understand the motivations, mechanics, and benefits of instituting data governance within an organization. This...
Getting Started with Master Data Management
Master data management forms part of an overall enterprise governance program that aims to establish trusted data throughout the enterprise. This white paper from Mike Ferguson of Intelligent Business Strategies...
Five Steps to More Valuable Enterprise Data
Companies worldwide struggle with inconsistent, inaccurate or unreliable data - and often don't know how to build more useful corporate information. This white paper examines a five-step method for...
The Evolution of Integration
Once upon a time life and information systems were simple. Then one day somebody let Pandora out of her box. Someone said -can't we add new requirements to these systems?...
