Importing xlsx datasets

[Rotman]

When importing excel datasets (xlsx), SAS puts a $ after the table name that I want to import (table refers to data from an Excel sheet). See snapshot below. Should there be $ after the Table name?

[SASJedi]

That is how the name is actually represented in Excel. The $ indicates it is a sheet name. SAS will remove the trailing $ from the SAS data set name created by importing the Excel data into SAS. 

[john_mccall]

Are you interested in using Proc Import, or the Libname statement to access xlsx files?  These are two good alternatives.

For a Libname example, you can use syntax to reference the xlsx engine, a true path name and xlsx workbook name if you have SAS/ACCESS to PC Files.

Libname XL   xlsx    "path/Name.xlsx";