SAS Add-In for Microsoft Office (Excel) - Exchanging Data Between SAS and Microsoft Excel - page 94

7.4 List of Examples

Table 7.3: List of Examples for SAS Add-In for Microsoft Office.

Example Number General Description

7.1 Open a SAS Dataset Using SAS Add-In for Microsoft Office.

7.2 Open a SAS Report Dataset (*.srx) Using SAS Add-In for

Microsoft Office.

7.5 Examples

Example 7.1 Open a SAS Dataset Using SAS Add-In for Microsoft Office
The first thing I do when I get a new piece of software is to figure out how to open a file. So, I will also use
that as my first example here. Using Excel 2013 and SAS 9.4, I click on the SAS Data Ribbon option on
the SAS tab. The pop-up View SAS Data menu appears, as shown in Figure 7.3 (View SAS Data). The
menu allows me to select the input SAS dataset, customize the display, and select the number of records
that will be visible. One of the features of the “View SAS Data” pop-up menu is the “Filter & Sort” option.
When that is selected, additional screens appear that allow you to select variables, filters, and sort order for
the input SAS data. Under the “Number of Records toView” option, be aware that when “All” is selected I
would always caution you to verify that the number of records and the number of columns that are actually
read into the Excel workbook match the number of rows and columns in the original SAS dataset. This is
especially true when reading more than 65,536 rows or 255 columns.

NOTE: The features described here do not require the activation of SAS Business Intelligence software,
but do require a license for SAS Business Intelligence software.