White Papers

Exploring the Undocumented PROC SQL_METHOD Option

Overview The SQL Procedure contains many powerful and elegant language features for SQL users to take advantage of. This paper explores the _METHOD option as an applications development and tuning tool. Attendees will learn how to use this undocumented and powerful option to better understand and control how a query processes.

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
May 29, 2009
Format
White Papers
Topics
Programming Languages, Database Management

Similiar White Papers

Building a Hybrid Data Warehouse Model

Building a Hybrid Data Warehouse Model

This paper discusses the hybrid design and provides a fully functional reference implementation. The system runs on Orac

Publisher: Oracle  |  Tags: data, database, warehouse

MySQL Stored Procedure Programming: Error Handling

MySQL Stored Procedure Programming: Error Handling

The perfect programmer, living in a perfect world, would always write programs that anticipate every possible circumstan

Publisher: O'Reilly Media  |  Tags: applications, business applications, server, shuttle, software

MSDN Webcast: Using LINQ With Relational Data (Level 100)

MSDN Webcast: Using LINQ With Relational Data (Level 100)

One of the most common forms of data used in applications today continues to be relational data that is stored in variou

Publisher: Microsoft  |  Tags: applications, data, database

MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)

MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)

This webcast is for Transact-SQL (T-SQL) lover. The presenter introduces to several new features of SQL Server 2008, inc

Publisher: Microsoft  |  Tags: data

Efficient Use of PL/SOL String Functions for Unicode Applications

Efficient Use of PL/SOL String Functions for Unicode Applications

This white paper focuses on performing implications of PL/SQL applications for Unicode database server using a UTF-8 dat

Publisher: Oracle Corporation  |  Tags: applications, database, server

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