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