What's New Table of Contents |
What's New in the SAS Add-In 2.1 for Microsoft Office
Overview
The SAS Add-In 2.1 for Microsoft Office has the following changes and enhancements:
- enhanced integration with Microsoft Office
- ability to publish documents and impact analysis support
- additional job administration and control
- support for additional data sources
- new SAS tasks
Enhanced Integration with Microsoft Office
The SAS add-in has improved its integration with Microsoft Office by adding the following functionality:
- support for Microsoft PowerPoint. You can insert SAS results in a new slide or add the results to an existing slide.
- ability to open a data source in a PivotTable in Microsoft Excel.
- ability to retain appearance and formatting changes when you refresh the results.
- ability to place multiple results on the same Excel worksheet.
- ability to place grouped analyses on a new worksheet.
- ability to modify the data source in Microsoft Excel, Microsoft Word, and Microsoft PowerPoint. You no longer have to open a data source first in Excel to modify the data.
- ability to copy a data source to a SAS server.
Ability to Publish Documents and Impact Analysis Support
Using the SAS Add-In for Microsoft Office, you can publish documents to a metadata repository. You can publish workbooks, documents, or slideshows to a metadata repository. When you publish a document to the metadata repository, information about all the data sources, stored processes, and the location of the document in WebDAV is saved to the repository. The document is saved in WebDAV.
Storing this metadata enables you to perform an impact analysis on a document. Impact analysis enables you to see where a data source came from and the items that are dependent on this source. This analysis enables you to know how changing a data source might affect other documents.
When you publish a document, the Verify Document for Impact Analysis dialog box opens to notify you that these data sources will not be tracked for impact analysis.
Additional Job Administration and Control
The SAS Add-In 2.1 for Microsoft Office has added the following job administration and control functionality:
- You can schedule a document. Scheduling when the SAS content in an Excel workbook, Word document, or PowerPoint presentation is refreshed enables you to have the most up-to-date data and reports. You can specify the date and time to refresh your content. You can also specify where the results are sent.
- You can refresh SAS content one item at a time or several at one time. On the Execution tab in the Properties dialog box, you can specify if the content is refreshed in the background or when you open the file.
- You can use the SAS Status window to view currently executing jobs, cancel any running jobs, or re-run any jobs that completed with an error.
- You can use the View SAS Contents dialog box to see the analyses and data sources that are inserted in the current Excel workbook, Word document, or PowerPoint presentation. From this window, you can delete content or save an XML representation of the contents to an external file.
Support for Additional Data Sources
In previous releases, you could select SAS data sources or Excel data as your data source. Starting with the SAS Add-In 2.1 for Microsoft Office, the following additional data sources are available:
- SAS Information Maps. An information map is a collection of data items and filters that describes and provides a view of physical data. You can create information maps using various SAS tools, such as SAS Information Map Studio. The SAS add-in enables you to open the information maps that have been created at your site.
- OLAP cubes. This data source is available only when you open data into a PivotTable.
New SAS Tasks
The following tasks are new for this release:
- Bar-Line Chart enables you to create a vertical bar chart with a line plot overlay.
- Compare Data enables you to create a report that compares two data sets or compares two variables within or across data sets.
- Characterize Data enables you to create a summary report, graphs, and frequency and univariate SAS data sets that describe the main characteristics of the data.
- Create Time Series Data enables you to convert transactional data into fixed-interval time series.
- Data Set Attributes enables you to create a report with the data set's creation date, location, and number of observations as well as the variable names, labels, types, and formats.
- Forecast Studio Create Project enables you to specify the forecasting variables, choose whether to forecast your data hierarchically, and specify the forecast horizon for a new SAS Forecast Studio project.
- 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.
- Model Scoring enables you to score a data set against an existing SAS Enterprise Miner predictive model.
New wizards provide a quick and easy way to use some of the SAS tasks and to contain a limited number of options. These wizards are helpful if you are new to a task or if you want to quickly generate an analysis. The following tasks have added a wizard view for this release:
- Bar Chart
- Line Chart
- Pie Chart
- Summary Statistics
- Summary Tables