White Papers

Data Matching

Overview It is rare that a single data set or table will hold all the data needed to answer the questions facing the business. People usually need to match data from multiple sources to assemble the meaningful intelligence required for the SAS experts to deliver to the business. Indeed, SAS provides substantial capability for the matching of data, but all too often an inefficient or inaccurate method can be employed leading to incomplete or incorrect results. This paper explores some data and code the correct syntax to provide the results needed. The paper deals with the data step and the process of bringing in multiple data sources.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
SAS Institute
File Format
PDF
Date Published
Jun 1, 2007
Format
White Papers
Topics
Knowledge and Data Management, Business Intelligence - Data Warehousing, Programming Languages

Similiar White Papers

SAS Data Integration Studio and SAS Macro - Working in Harmony for Data Warehousing Projects

SAS Data Integration Studio and SAS Macro - Working in Harmony for Data Warehousing Projects

SAS Data Integration (DI) Studio is gaining popularity as a Data Warehousing tool. As a gateway to the SAS Metadata Serv

Publisher: SAS Institute  |  Tags: data, fda, metadata

Using SAS Arrays to Manipulate Data

Using SAS Arrays to Manipulate Data

The DATA step has been described as the best data manipulator in the business. One of the constructs that gives the DATA

Publisher: SAS Institute  |  Tags: applications, data

"Min Logistikk" - Using SAS BI Web Services in a Service Oriented Architecture at Norway Post Delivering Information Securely to Customers on Extranet

"Min Logistikk" - Using SAS BI Web Services in a Service Oriented Architecture at Norway Post Delivering Information Securely to Customers on Extranet

This paper describes the systems architecture of one the reporting solutions that were developed through the program "IK

Publisher: SAS Institute  |  Tags: bi, data, data warehouse, java

SAS Institute White Papers

A Clever Demonstration of the SAS SUBSTR Function

A Clever Demonstration of the SAS SUBSTR Function

The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either s

Publisher: SAS Institute

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

The explosion of customer data in the last twenty years has increased the need for data mining aimed at Customer Relatio

Publisher: SAS Institute  |  Tags: crm, customer service, data, data mining

An Animated Guide: Proc Transpose

An Animated Guide: Proc Transpose

If one can think about a SAS data set as being made up of columns and rows, one can say Proc Transpose "Flips" the colum

Publisher: SAS Institute  |  Tags: data

Cool New Features in SAS Enterprise Miner 5.3

Cool New Features in SAS Enterprise Miner 5.3

SAS released Enterprise Miner 5.3 in late 2007 with a veritable plethora of cool new features for data miners everywhere

Publisher: SAS Institute  |  Tags: data, software

An Introduction to SAS Character Functions

An Introduction to SAS Character Functions

SAS software is especially rich in its assortment of functions that deal with character data. This class of functions is

Publisher: SAS Institute  |  Tags: data, software