topic Re: Importing xlsx datasets in SAS Programming

Importing xlsx datasets

Rotman — Fri, 30 Dec 2022 00:25:31 GMT

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?

Re: Importing xlsx datasets

SASJedi — Mon, 02 Jan 2023 14:48:52 GMT

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.

Re: Importing xlsx datasets

john_mccall — Mon, 02 Jan 2023 17:08:21 GMT

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