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 ...

Get SAS Certified Specialist Prep Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.