What's New in the SAS Add-In 4.2 for Microsoft Office
Overview
The SAS Add-In 4.2 for Microsoft Office has the following changes and enhancements:
For information about the new features and enhancements in the SAS Add-In 4.3 for Microsoft Office, see What's New in
the SAS Add-In 4.3 for Microsoft Office.
Role-Based Settings
Because the SAS Add-In for Microsoft Office is used by a variety of people and groups within an organization, your administrator might choose to restrict the menu items and functionality that users can access. By default, the SAS add-in ships with several default roles. These roles manage the availability of application features.
New Tools for Managing Server Connections and Profiles
The Connections window now enables you to examine your metadata server connection and perform the following tasks:
- add, modify, or delete a profile. You can also specify the profile to use when working with the SAS add-in.
- change your default server. You can specify a default server for a profile. You need to connect to a server to access SAS data sources and to run SAS tasks.
- specify whether to automatically update the configuration.
Specifying Security Settings
The new Security tab in the SAS Add-In Options dialog box enables you to specify the security settings for password-protected data in a workbook. You can specify the duration of security credentials.
Previewing Results and Restoring Content
If you are using the SAS Report format for your results, you can now preview your results before they are inserted into Excel, Word, or PowerPoint. Using the new Preview and Preview Changes windows, you can choose to insert all of the results or only selected items.
If you delete SAS content or choose not to include content in the results, you can now restore content by using the new Restore Content window. From this window, you can choose to restore all of the content or only selected items.
Opening an OLAP Cube into a PivotTable
When an OLAP cube is opened into the PivotTable report, the SAS add-in automatically populates the rows and columns of the PivotTable. However, you can add additional variables, calculated measures, or calculated members to the PivotTable. Using the SAS add-in, you can now create calculated members and calculated measures for an OLAP cube.
New and Enhanced SAS Tasks
General Enhancements
-
When you open a task, the task uses the active data source as the input data source by default. Now, from the Data panel for the task or the Verify Data step of the wizard, you can create a filter.
- In the advanced tasks, you can now edit and view the properties of the task from the new Properties panel.
- Task templates enable you to save your settings for a specific task to a template. You can then run that template with any input data source. After they have been created, these templates are available to use in SAS Enterprise Guide and the SAS Add-In for Microsoft Office.
Enhanced Tasks
The following tasks have been enhanced:
- The Bar Chart task now supports multiple chart variables within a single group variable. Two new bar types, Multiple Measures Vertical Groups and Multiple Measures Horizontal Groups, have been added.
- In the Bar-Line Chart task, you can now create multiple line plots and specify the line statistics for each individual plot. You can also create multiple legends for the chart.
- In the Correlations task, you can now use the Fisher options for Pearson or Spearman correlations.
- The following tasks now support ODS statistical graphics. The tasks are listed by category.
- ANOVA: Linear Models, One-Way ANOVA, t Test
- Describe: Distribution Analysis, One-Way Frequencies, Summary Statistics
- Multivariate: Cluster Analysis, Correlations, Factor Analysis, Mixed Models, Principal Components
- Regression: Generalized Linear Models, Linear Regression, Logistic Regression
- Survival Analysis: Life Tables, Proportional Hazards
- Time Series: Create Time Series Data
New Tasks
The new List Report Wizard enables you to create detail or summary reports. A detail report contains one row for every observation selected for the report. A summary report consolidates data so that each row represents multiple observations.
The following tasks are available in a maintenance release of the SAS Add-In 4.2 for Microsoft Office:
- Forecast Studio Create Project enables you to create a new SAS Forecast Studio project. You can specify the forecasting variables, choose whether to forecast your data hierarchically, and specify the forecast horizon.
- Forecast Studio Open Project enables you to open the selected series from an existing SAS Forecast Studio project and specify how to display the results.
- Forecast Studio Override Project enables you to submit overrides for the forecast data in an existing SAS Forecast Studio project.
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.