SAS® 9.2 Software Key Highlights

WHITE PAPER SAS® 9.2 Software Key Highlights SAS® 9.2 SoftwAre Key HigHligHtS Table of Contents About the SAS® 9.2 release ......................................................................... 1 Why upgrade to SAS® 9.2? .......................................................................... 1 What is included in SAS® 9.2? ..................................................................... 1 New software in SAS® 9.2 ........................................................................... 2 SAS® Data Surveyor for Clickstream Data ........................................... 2 SAS® Data Surveyor for Salesforce.com .............................................. 3 SAS® Scoring Accelerator for Teradata ................................................ 3 Enhancements to Base SAS® software ....................................................... 3 Enhancements to SAS/GRAPH® software ................................................... 4 ODS Statistical Graphics ............................................................................. 5 Enhancements to data access software..................................................... 5 New in-database feature improves performance................................ 6 Architectural, management and security enhancements ......................... 6 Architectural enhancements in SAS® 9.2 ............................................ 6 System management features in SAS® 9.2 ......................................... 7 Security features in SAS® 9.2 .............................................................. 8 Enhancements to analytics software ......................................................... 9 SAS® Enterprise Miner™ software ....................................................... 9 SAS/ETS® software ............................................................................ 10 SAS/Genetics™ software .................................................................... 10 SAS/IML® software ............................................................................ 11 SAS/OR® software .............................................................................. 11 SAS/QC® software .............................................................................. 11 SAS/STAT® software........................................................................... 12 Enhancements to BI and data integration client applications (general) . 12 Enhancements to SAS® Business Intelligence software clients .............. 14 SAS® Add-In for Microsoft Office ...................................................... 14 SAS® BI Dashboard ........................................................................... 14 SAS® Information Delivery Portal ....................................................... 15 SAS® Information Map Studio ............................................................ 15 SAS® OLAP Cube Studio ..................................................................... 16 SAS® Web Report Studio .................................................................... 16 i SAS® 9.2 SoftwAre Key HigHligHtS Enhancements to SAS® Data Integration software clients....................... 17 SAS® Data Integration Studio ............................................................ 17 Other data integration software enhancements ................................ 18 Enhancements to SAS® Enterprise Guide® ................................................ 19 Installing, configuring and migrating to SAS® 9.2 .................................... 20 Installation and configuration enhancements .................................. 20 Running SAS® 9.2 and SAS® 9.1.3 on the same machine .................. 20 Moving metadata and other content to SAS® 9.2 ............................. 21 ii SAS® 9.2 SoftwAre Key HigHligHtS About the SAS® 9.2 release SAS 9.2 was released to customers in two phases. The first phase, released in March 2008, included Base SAS and products such as SAS/ACCESS®, SAS/GRAPH®, SAS/STAT®, SAS/Genetics™, SAS/ETS®, SAS/IML®, SAS/QC® and SAS/OR®. The second phase was released in February 2009. This phase included SAS Business Intelligence and SAS Data Integration software, SAS server and middle-tier components, and updates for the software released in the first phase. Additional products and solutions that use the SAS server and middle-tier components are being released on an ongoing basis. Why upgrade to SAS® 9.2? By upgrading to SAS 9.2, you will be able to take advantage of the large number of new features and performance improvements that are included in this release. In addition, you will be able to take advantage of future enhancements, maintenance updates and new SAS products and solutions that run with the updated software. Upgrading will also keep your SAS software compatible with operating systems and other third-party software products as they are upgraded. If your current configuration includes a SAS Metadata Server, tools are provided for migrating your metadata from SAS 9.1.3 to SAS 9.2. See “Moving metadata and other content to SAS® 9.2” (page 20). The features and enhancements in SAS 9.2 are summarized in this paper. For information about ordering SAS 9.2, please contact your account executive. What is included in SAS® 9.2? The majority of the enhancements included in SAS 9.2 are a direct response to requests from our existing customer base. Base SAS 9.2 includes more analytical and graphical capabilities, such as Output Delivery System (ODS) Statistical Graphics and SAS/GRAPH support for ODS styles. New and enhanced features in SAS/STAT, SAS/Genetics, SAS/ETS, SAS/IML, SAS/QC and SAS/OR software enable you to perform a wider range of statistical and analytical tasks. With the enhancements to SAS Data Integration Studio (the GUI component included with SAS Enterprise Data Integration Server and SAS Data Integration Server), you can create and debug jobs more efficiently. In the SAS Business Intelligence applications, all user interfaces have been updated to increase productivity and usability. 1 SAS® 9.2 SoftwAre Key HigHligHtS SAS 9.2 includes significant performance improvements through better use of the underlying hardware and software. The improvements include more widespread use of 64-bit computing, as well as an increased ability to use and manage grids. Support for multithreaded processing has been extended across the platform, from SAS procedures to SAS servers to grid enablement. In addition, new in-database features substantially improve performance by moving analytic tasks closer to your data. For configurations that use the SAS Metadata Server, SAS 9.2 provides a substantially higher level of integration with IT infrastructures. Management of SAS servers is improved through a new logging framework, a new management interface in SAS Management Console and integration with industry-standard monitoring software. Security features have been enhanced to be more robust and IT-friendly. For all types of configurations, you can now download SAS software automatically through the Internet. In addition, software installation and configuration is significantly easier and faster. The new SAS Deployment Wizard prompts for user entries and checks for required software at the beginning so that the rest of the process can run silently and unattended. For more information on SAS 9.2, including comprehensive What’s New information, please visit http://support.sas.com/documentation/whatsnew/index.html. The product pages on the SAS Support Customer Web site also are a useful reference for SAS users: http://support.sas.com/software/products/index.html. New software in SAS® 9.2 SAS® Data Surveyor for Clickstream Data SAS Data Surveyor for Clickstream Data automates the extraction of useful information from large volumes of clickstream data collected in Web logs. It includes templates for common process flows that are used to cleanse and enrich the data. You can customize the template jobs for your own Web logs and outputs. 2 SAS® 9.2 SoftwAre Key HigHligHtS SAS® Data Surveyor for Salesforce.com SAS 9.2 includes a new data surveyor that gives you access to data from Salesforce.com customer relationship management (CRM) software. This data surveyor is provided through a partnership with Composite Software. The new Composite Software functionality is also incorporated into data surveyors for other CRM and enterprise resource planning (ERP) systems, including PeopleSoft, Oracle Applications and Siebel. In previous releases, SAS integrated data from these systems by accessing the underlying database with SAS/ACCESS software. The new data surveyors in this release use the vendor API and certified interfaces, and they comply with the security of each application. SAS® Scoring Accelerator for Teradata SAS Scoring Accelerator for Teradata enables you to translate scoring models created in SAS® Enterprise Miner™ into functions that are executed directly within the Teradata Enterprise Data Warehouse (EDW). This product enhances the performance of model scoring, resulting in faster processing of analytic models. Enhancements to Base SAS® software Base SAS 9.2 includes many enhancements. The SAS customer support Web site, http://support.sas.