SAS Technical Papers » Performance
Papers Topic List |
| Date | Title | File Size |
| March 2008 | New SAS Performance Optimizations to Enhance Your SAS Client and Solution
Access to the Database (PDF) This paper presents the major SQL optimizations that have been added to PROC SQL to enhance its performance for SAS 9.2. These optimizations are the result of analyzing SQL queries generated by SAS clients and solutions, and finding new and innovative ways to squeeze out more performance. |
73 KB |
| November 2007 | Configuring EMC CLARiiON for SAS Business Intelligence Platforms (PDF) Deploying SAS applications optimally with data stored on EMC CLARiiON systems requires a close collaboration between SAS application programmers, database administrators, and storage administrators. Understanding how SAS typically drives I/O from the server environment and how CLARiiON works internally in servicing different types of I/O patterns is the key to enabling that effective collaboration. |
518 KB |
| January 2007 | ETL Performance Tuning Tips (PDF) As data volumes grow and the windows of time that ETL (extract, transform, and load) jobs are allowed to run shrink, ETL developers are faced with the challenge of creating highly efficient ETL jobs. Well-performing ETL jobs is a requirement. This paper provides important ETL performance, tuning, and capacity information for SAS®9 and SAS Data Integration Studio. ETL concepts are introduced and ETL performance topics are covered in depth and with examples as needed. Topics include how to analyze and debug flows, gain efficiency quickly, set up the system environment, and, when necessary, customize advanced performance techniques. |
1,799 KB |
| May 2005 | IBM and SAS: Working Together to Promote Business Innovations with Grid Computing (PDF) By combining IBM and SAS' leadership in the IT field, we can provide value-added solutions, state-of-the-art technologies, and extensive knowledge and experience to our mutual customers to solve their increasingly complex computing requirements. |
943 KB |