| Provides step-by-step instructions for analyzing data in Microsoft Excel. You will be guided through several SAS tasks and shown how you can harness the power of SAS in Microsoft Excel. The scenarios in the book use sample data that is provided with Base SAS software, so you can follow the instructions to perform this analysis.
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. |
