Reading Microsoft Excel Data with the XLSX Engine
Running SAS with Microsoft Excel
The examples in this section are based on SAS 9.4 64-bit running with Microsoft Office 2016 64-bit on Microsoft Windows 10 64-bit.
This configuration does not require the SAS/ACCESS PC Files Server. If SAS runs in a UNIX environment and needs to access Excel files on Microsoft Windows, you must license the SAS/ACCESS PC Files Server.
Steps for Reading Excel Data
To read the Excel workbook file, SAS must receive the following information in the DATA step:
a libref to reference the Excel workbook to be read
the name of the Excel worksheet that is to be read
The table below outlines the basic statements that are used in a program that reads ...