BookmarkSubscribeRSS Feed
Rotman
Calcite | Level 5

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?

Rotman_0-1672359889767.png

 

2 REPLIES 2
SASJedi
Ammonite | Level 13

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. 

Check out my Jedi SAS Tricks for SAS Users
john_mccall
SAS Employee

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";

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 820 views
  • 2 likes
  • 3 in conversation