What Is a Published Document?

After you have completed an analysis, you might want to share the results with others at your site. Published documents are Excel, Word, or PowerPoint documents that are saved to a common repository.
Publishing your documents to a common repository has the following benefits:
§ The workbooks, documents, and presentations in this repository can be opened by others at your site.
§ When you publish the workbook, document, or presentation to the metadata repository, information about all the data sources is saved to the repository. Storing this metadata in the repository 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 depend on this source. This analysis enables you to know how changing a data source might affect other documents.

Note
To publish a document, your site administrator must have installed SAS Web Report Studio on the same metadata server. If you cannot publish documents, contact your site administrator. D

Sending Results from Excel

After you performed your initial analysis of the company’s 2006 sales data in Excel, your managers asked you to create a short presentation for the yearly sales meeting. This presentation should include the following:
§ the total sales for each product
§ the average sales, inventory, and returns for each product
From Excel, you can select the results from the Shoe Sales 2006 workbook to send to Word or to PowerPoint. When you select the SAS content to send, the current results for that analysis are automatically displayed in Word or PowerPoint. To make sure that the most up-to-date results are displayed in Word or PowerPoint, you should refresh the analysis after the results are sent to these applications.

Note
You can send only SAS content from Excel to Word or PowerPoint. Any formatting or text changes that you made to the SAS content are not sent. Only the results are re-opened in Word or PowerPoint.
You cannot send a SAS data source or data in an Excel worksheet. Word and PowerPoint are unable to open and read an Excel data source. Additionally, you cannot send a PivotTable report to Word or PowerPoint. D

Accessibility Features of the SAS Add-In for Microsoft Office

The SAS Add-In for Microsoft Office includes accessibility and compatibility features that improve usability of the product for users with disabilities. These features are related to accessibility standards for electronic information technology adopted by the U.S. Government under Section 508 of the U.S. Rehabilitation Act of 1973, as amended. For more information about the accessibility of the SAS Add-In for Microsoft, see the online Help.

Benefits to Using the SAS Add-In for Microsoft Office

Most of the SAS add-in functionality is identical in Excel, Word, and PowerPoint; for example, you can run analyses and reports in all three applications.
The SAS add-in extends the functionality in Excel, Word, and PowerPoint by enabling you to complete the following tasks:
§ Access SAS data sources as the input data for your analysis. You can view any SAS data source or any data source available from your SAS server (including databases such as Oracle, Teradata, and DB2).
§ Perform more sophisticated analysis and computations than what is available in Microsoft Excel. For example, one of the sophisticated analyses that SAS provides is the Canonical Correlation task. This task enables you to examine the relationship between a linear combination of a set of X variables and a linear combination of a set of Y variables. You might run a canonical correlation analysis to determine the degree of correspondence between a set of job characteristics and a set of measures of employee satisfaction. This extends the correlation analysis that is available in Excel. You can run these sophisticated analyses and computations in Excel, Word, or PowerPoint.
§ Run custom analyses that were developed by others at your company. Using the SAS add-in, you can also access programs, which are called SAS Stored Processes. These programs are customized SAS code that is developed by business analysts or your IT department. Running these programs enables you to quickly generate a custom report without writing any SAS code.
§ Refresh the content in the Excel worksheet, Word document, or PowerPoint presentation on demand or automatically at a specified time. Scheduling when the content is refreshed enables you to have the most up-to-date data and reports when you need it.
§ Publish the results to a central location. By publishing a document, you can share it with others without having to e-mail it. If you publish the document to a metadata repository, then you can perform an impact analysis on the 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.
Additional functionality is available in Excel. In Microsoft Excel, you can also complete the following tasks:
§ Access and view data sources that exceed the 65,536 record limitation in Excel. The SAS add-in does its processing on the server, which enables it to by-pass the record limitation in Excel.
§ Copy data to a SAS server. You can copy an Excel data source or a SAS data source to the SAS server. After a data source is copied to a SAS server, it becomes a SAS data set. This enables you to share Excel data with Word and PowerPoint users at your site. This functionality also enables Excel users to update information in a SAS data source and upload it to the SAS server.
§ Send the results from an analysis that you ran in Excel to a Word document or PowerPoint presentation. For example, you ran analysis of your company’s sales for this year, and now you need to give a presentation of the results. Using this functionality in Excel, you can select which results to include in a PowerPoint presentation. This saves you time because you only need to run the analysis once.
This book explores some of the basic tasks that you can perform in Excel.

What Is the SAS Add-In for Microsoft Office?

The SAS Add-In for Microsoft Office extends the functionality of Microsoft Excel, Microsoft Word, and Microsoft PowerPoint by enabling you to access SAS analytics and SAS reporting functionality without any SAS programming experience. The SAS add-in is designed for users who are familiar with these Microsoft Office programs but who might be new to SAS.
The SAS add-in includes approximately 80 SAS tasks that enable you to perform a variety of analyses. Examples of analyses that you can perform include linear and nonlinear regressions, multivariate analyses, time series analyses, one-way frequencies, and summary statistics. The SAS add-in enables you to refresh these analyses so that your results include the most up-to-date information. You can also easily share the results with others at your site.
When the SAS add-in is installed on your computer, a SAS menu and the SAS Analysis Tools toolbar are automatically integrated into Excel, Word, and PowerPoint. (In Excel, the SAS Data Tools toolbar is also available.) The menu and toolbars enable you to access the SAS analytics and reporting functionality directly from these Microsoft Office programs without having to open a separate SAS interface.