is any SAS name that associates SAS with the SAS library where the Microsoft Excel spreadsheet is stored. The association between a libref and a SAS library lasts only for the duration of the SAS session or until you change the libref or discontinue it with another LIBNAME statement.
is the SAS LIBNAME engine name for an XLSX file format. The LIBNAME statement associates a libref with an XLSX engine that supports connections to Microsoft Excel 2007, 2010, and later files.
Example | This LIBNAME statement specifies Wsinv as a reference
(that is, libref) to a SAS library. The XLSX engine specifies an engine
that supports the connection to the file type .XLSX.LIBNAME wsinv XLSX 'c:WestSectorQ1_Invoices.xlsx'; |
is the physical-path and filename of a Microsoft Excel 2007 or later workbook. Using the extension (.xlsx) is required. Enclose the path and workbook name in quotation marks.
define how SAS interacts with the external data source (in this case, XLSX files), providing enhanced control of how SAS processes data source objects.
clears one libref.
specifies that the CLEAR or LIST argument applies to all librefs.
writes the attributes of one or more SAS/ACCESS libraries or SAS libraries to the SAS log.
Examples | List the attributes of a single library:LIBNAME LIBREF LIST; |
List the attributes of all the libraries:LIBNAME _ALL_ LIST; |