Resources

SAS Products

SAS® Add-In for Microsoft Office

Samples for the SAS Add-In 4.3 for Microsoft Office

Note: These samples assume that the default workspace for your SAS metadata server is SASApp.

These samples show how you can use the SAS Add-In 4.3 for Microsoft Office to generate professional-looking worksheets, documents, and presentations. Many of these samples contain Visual Basic automation to demonstrate the extra functionality Visual Basic can provide to an Office document. Samples are available for Microsoft Excel, Microsoft Word, and Microsoft PowerPoint.

Step 1: You must OPEN AND RUN "RunFirst.xlsm" before you can start using the Samples

Open ZIP

Here is a description of what the samples that are included in the zip file.


Microsoft Excel Samples

FBI Crime Data - In this sample, you learn how to use Microsoft Excel data to generate SAS content. This sample uses the same input data source as the Crime Data sample, which is a Microsoft PowerPoint presentation. However, in addition to line plots and bar charts, this sample includes a correlation analysis. Because this sample is in Microsoft Excel, you can edit the input data source to update the results of the analysis and the graphs.

FedReserveRate - In this sample, you learn how to use Microsoft Excel data to generate SAS content. The Excel data is used as the input data source for linear regression, summary statistics, and basic forecasting. In the basic forecasting analysis, you also learn how to use macro variables to generate a new simulation of the Federal Reserve rate. Finally, a line plot displays the Federal Reserve rates over time.

Map Charts - In this sample, you learn how to include map charts in your Microsoft Excel worksheet. Several types of map charts are shown, so you can see the benefits of each type of chart. You also learn how you can edit the input data source to change the results of the map chart.

State SAT - In this sample, you learn how to incorporate data, the results from an analysis, and graphs into your Microsoft Excel worksheet. This sample uses the input data source as the State SAT Analysis sample, which is a Microsoft PowerPoint presentation. You also learn how you can edit the input data source to change the results of the distribution analysis and the bar chart.

Microsoft Word Samples

College - In this sample, you learn how to incorporate SAS content into a Microsoft Word document that will be used as a pamphlet, fact sheet, or white paper. The SAS content includes bar charts and pie charts.

Soccer Club - In this sample, you learn how to include SAS content in a Microsoft Word document. Initially, all of the teams in the soccer club are listed in no particular order. Using macro variables, you can specify whether to rank all of the teams or whether to rank the data by conference.

Microsoft PowerPoint Samples

Crime Analysis - In this sample, you learn how to include SAS content in your Microsoft PowerPoint presentations. The SAS content includes bar charts and line plots. You learn how to customize each graph, include a legend, and provide supporting text on the slide. You also learn how you can refresh the content of several graphs during your presentation.

State SAT Analysis - In this sample, you learn how you can include SAS content and text in your Microsoft PowerPoint presentations. The SAS content includes vertical bar charts, horizontal bar charts, and line plots.

Uninsured America - In this sample, you learn how to incorporate graphs into your Microsoft PowerPoint presentations. The SAS content includes a map chart, a bubble chart, and a bar chart. You also learn how you can refresh the content of the bar chart during your presentation.