Reading Microsoft Excel Data
Overview
In
addition to reading raw data files, SAS can also read Microsoft
Excel data. Whether the input data source is a SAS data set, a raw
data file, or a file from another application, you use the DATA
step to create a SAS data set. The difference between reading these
various types of input is in how you reference the data. To read in
Excel data you use one of the following methods:
-
SAS/ACCESS LIBNAME statement
-
Import Wizard
Remember, the Base SAS LIBNAME
statement associates a SAS name (libref) with a SAS DATA library by
pointing to its physical location. But, the SAS/ACCESS LIBNAME
statement associates a SAS name with an Excel workbook file by
pointing to its location.
In doing so, the ...
Get SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition 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.
