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";
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: