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?
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.
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";
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.