Beginning with SAS 9.0, a libref with the Excel engine can be assigned
to Excel workbook files.  After successfully assigning a LIBNAME
statement to an Excel Workbook file using the Excel engine, there are
icons in the library in the SAS Explorer for Worksheet names and Range
names.  The objects with names that end with the $ (dollar sign) are
Worksheet names.

To reference the Excel Worksheet name in your SAS code, using the
libref, you must use the n-literal (Name Literal).  For example:

  libname mylib "C:\My Documents\MyFile.xls";

  proc print data=mylib.'Sheet1$'n; run;

  data sasuser.new;
    set mylib.'Sheet3$'n;
  run;

Operating System and Release Information