White Papers

A Faster Index for Sorted SAS Datasets

Category: Data Management, Software and Web Development

Overview In a NESUG 2007 paper with Shuguang Zhang, The author demonstrated a compressed index (termed "Condensed index" in that paper) which provided significant performance gains (about 33% elapsed time and cpu time) in retrieving subsets from sorted datasets in which each level of the sort variables(s) has many observations, and the sort variable was used as the selection criterion. This paper extends the compressed index in two ways: replication of a SAS composite index, and further performance gains (up to 50%) by selectively replacing direct access (i.e. POINT=) techniques with sequential access (FIRSTOBS and LASTOBS). This paper demonstrates, with sample DATA steps, how to create and use a compressed index, and compares its performance to SAS indices, and to the previous results.

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 Development, Knowledge and Data Management

Similiar White Papers

Software Developer Creates an Affordable, Flexible Lab Information Management System

Sciformatix wanted to make it easier and more cost-effective for scientists and other laboratory workers to manage infor

Publisher: Microsoft | Tags: information management, management

SAS for Real-Time Applications

The SAS language is well suited for expressing program logic; people have been using it for over 30 years. There are man

Publisher: SAS Institute | Tags: applications, real-time

Best Practices for Gaining Visibility Into Application Performance

This white paper explains why having a "360-degree view," or comprehensive visibility, into all of your mission-critical

Publisher: SL Corporation | Tags: applications, business applications, management

Sterling Insurance: Cuts Quote Time by 90 Per Cent

Sterling Insurance Group needed to change its application deployment infrastructure. The company replaced the solution,

Publisher: Microsoft | Tags: infrastructure, sterling, time

IBM Case Study: GILFAM

GILFAM, the public organization whose mission is to automate the land registry in this area of France, engaged IBM to de

Publisher: IBM

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 »