Resources

What's New Table of Contents  

New Products in SAS 9.1, 9.1.2, and 9.1.3: SAS Intelligence Platform

SAS creates and delivers enterprise intelligence through the SAS Intelligence Platform. This cohesive platform is based on an architecture that fully integrates SAS technologies in data extraction, transformation, and loading (ETL); data storage; business intelligence; and analytic intelligence. These capabilities provide the end-to-end infrastructure that is necessary for exploring, analyzing, optimizing, reporting, and understanding your data.

The following SAS Intelligence Platform products are new in SAS 9.1, 9.1.2, and 9.1.3:

For documentation about how to install and administer the SAS 9.1.3 Intelligence Platform, see http://support.sas.com/913administration. These documents are also available from SAS 9.1.3 OnlineDoc on the Web at http://support.sas.com/onlinedoc/913/docMainpage.jsp.

SAS Information Map Studio

SAS Information Map Studio is an application that enables you to create and manage SAS Information Maps—business metadata about your physical data. SAS Information Map Studio provides a graphical user interface that enables you, the information architect, to create and view information maps.

Information maps are user-friendly metadata definitions of physical data sources that enable your business users to query a data warehouse in order to meet specific business needs. Information maps enable business users to easily access enterprise-wide data by providing the following benefits:

  • Users are shielded from the complexities of the physical data.
  • Data storage is transparent to the users, regardless of whether the data is relational or multidimensional or whether the data is in a SAS data set or in a third-party database system.
  • Business formulas and calculations are predefined, which makes them usable on a consistent basis.
  • Users can easily query data for answers to business questions without having to know query languages.

For more information about the current release, see What's New in SAS Information Map Studio 3.1.

SAS Web Report Studio

SAS Web Report Studio is a Web-based application that enables you to create, view, and organize reports. You can use SAS Web Report Studio for the following tasks:

Creating reports

  • Beginning with a simple and intuitive view of your data provided by SAS Information Maps (created in SAS Information Map Studio), you can create reports based on either relational or multidimensional data sources.
  • You can use the Report Wizard to quickly create simple reports or the Edit Report view to create sophisticated reports that have multiple data sources, each of which can be filtered. These reports can include various combinations of list tables, crosstabulation tables, and graphs. Using the Edit Report view, you can adjust the style to globally change colors and fonts.
  • You can also insert stored processes that take the results from a block of SAS code and embed those results directly into a report.

Viewing and working with reports

While viewing reports by using a thin client (a Web browser), you can filter, sort, and rank the data that is shown in list tables, crosstabulation tables, and graphs. With multidimensional data, you can drill down on data in crosstabulation tables and graphs and drill through to the underlying detail.

Organizing reports

Reports can be shared with others or kept private. You can create folders and sub-folders for organizing your reports. Information consumers can use keywords to find the reports that they need.

Printing and exporting reports

You can preview reports in PDF and print the report, or save and e-mail it later. You have control over many printing options, including page orientation, page range, and size of the tables and graphs. You can also export data as a spreadsheet.

For more information about the current release, see What's New in SAS Web Report Studio 3.1.

SAS Data Integration Studio

SAS Data Integration Studio (formerly named SAS ETL Studio) is a visual design tool that enables you to consolidate and manage enterprise data from a variety of source systems, applications, and technologies. This software enables you to create process flows that accomplish the following tasks:

  • extract, transform, and load (ETL) data for use in data warehouses and data marts
  • cleanse, migrate, synchronize, replicate, and promote data for applications and business services

SAS Data Integration Studio enables you to integrate information from any platform that is accessible to SAS and from any format that is accessible to SAS.

The SAS Data Integration Studio: User's Guide is available at support.sas.com.

For more information about the current release, see What's New in SAS Data Integration Studio 3.4.

SAS Management Console

SAS Management Console is a Java application that provides a single point of control for managing resources that are used throughout the SAS Intelligence Platform. Rather than using a separate administrative interface for each application in your computing environment, you can use the single interface in SAS Management Console to perform the administrative tasks that are required in order to create and maintain an integrated environment across multiple platforms. For more information about SAS Management Console, see What's New in SAS Management Console 9.1.2 and 9.1.3.

SAS Add-In for Microsoft Office

The SAS Add-In for Microsoft Office is an integral part of a complete end-to-end business intelligence solution. The SAS add-in is a Component Object Model (COM) add-in that extends Microsoft Office by enabling you to harness the power of SAS analytics, access relational data sources directly from Microsoft Word, Microsoft Excel, and Microsoft PowerPoint, and create reports within Microsoft Office. You can use the SAS add-in for the following tasks:

Running analyses

  • Dynamically execute stored processes and SAS tasks.
  • Search for stored processes by name, date, or keyword.
  • Analyze SAS or Excel data by using SAS tasks.

Working with results from your stored processes and SAS tasks

  • Embed the results in your documents and spreadsheets.
  • Refresh the existing content to display the most updated results.
  • Send the results from Microsoft Excel to Microsoft Word or Microsoft PowerPoint.
  • Create reports that include the results, and apply custom styles to the reports.

Working with data

  • Access and view SAS data sources or any data source that is available from your SAS server. There is no size limit on the SAS data sources that you can open.
  • Filter your data by using an intuitive user interface or an advanced SQL editor.
  • Sort your data by an unlimited number of variables.
  • Refresh your data sets to incorporate any changes that were made to a data source that is saved on a server.

For more information about the current release, see What's New in the SAS Add-In 2.1 for Microsoft Office.

SAS Personal Login Manager

SAS Personal Login Manager is an application that enables you to manage the metadata that describes your user accounts. In a SAS Metadata Server, the user ID and password for each user account can be stored as a login. Each login should correspond to a user account that has been established for you in the operating system (or with an alternative authentication provider such as Microsoft Active Directory Server or Lightweight Directory Access Protocol Server). You can use the SAS Personal Login Manager to add, update, and remove your logins. For example, after you change the password for your operating system user account, you can use the SAS Personal Login Manager to update that password in the SAS Metadata Server. This enables you to keep the logins that you own in the metadata synchronized with your user accounts. For more information, see the Help for the SAS Personal Login Manager.