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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
