White Papers

Avoiding Common Traps When Accessing RDBMS Data

Category: Data Management, Software and Web Development

Tags: data

Overview Accessing data from databases such as Oracle and SQL Server has become an increasingly common requirement for SAS programmers. SAS offers powerful and flexible capabilities for accessing such data, and many aspects of this process are quite straightforward, especially when LIBNAME engines are used. However, there are a number of traps that lurk for the unwary that can potentially produce unexpected error messages, incorrect output, or frantic calls from the normally-friendly Database Administrator. This paper highlights some of the most common traps and explains how to avoid them.

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: Application Servers, Database Management

Similiar White Papers

Fibre Channel and iSCSI Performance Comparison for DSS Workloads Using SQL Server 2005

For many years, large enterprises have relied on Fibre Channel (FCP) as the default Storage Area Network (SAN) protocol

Publisher: Network Appliance (NetApp) | Tags: database, ethernet, ip, tco

Software Company Creates Automated "Database Factory" Using SQL Server 2008

CyberSavvy believes in using software automation to make life easier for its customers. Its Software as a Service soluti

Publisher: Microsoft Tips | Tags: data, database, server, software

MSDN Webcast: Windows SharePoint Services and Forms Services (Level 200)

The presenter of this webcast will explore Microsoft Office InfoPath 2007 as a form tool and describe how one can host f

Publisher: Microsoft | Tags: microsoft office, office, sharepoint

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: 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

SAS Institute White Papers

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

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

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »