topic Re: SAS version numbers versus XLSX libname engine - question in SAS Programming

SAS version numbers versus XLSX libname engine - question

Unagi — Fri, 07 Apr 2023 18:06:30 GMT

Hello, had a question regarding the XLSX libname engine. I am running SAS EG version 9.04.01M5.

I can successfully assign the library.

I am trying to simply use proc contents on the assigned XLSX library, but the library doesn't show the sheet names and the engine doesn't operate like I would expect it to. Do I have too old a version to utilize the XLSX engine?

Re: SAS version numbers versus XLSX libname engine - question

Kurt_Bremser — Fri, 07 Apr 2023 18:31:39 GMT

Since the XLSX LIBNAME can also be used to create a new Excel file, a successful LIBNAME does not mean that the file actually exists in the context of the SAS session. Keep in mind that your SAS may run on a server which has no connection to your desktop's drives.

Re: SAS version numbers versus XLSX libname engine - question

AhmedAl_Attar — Fri, 07 Apr 2023 19:58:26 GMT

@Unagi

Actually according to this Blog https://blogs.sas.com/content/sasdummy/2015/05/20/using-libname-xlsx-to-read-and-write-excel-files/

The XLSX engine was added to SAS 9.4 M2

From the blog, to see the sheet names stored in a specified workbook, try this code

/* because Excel field names often have spaces */
options validvarname=any;
libname xl XLSX '/folders/myfolders/sas_tech_talks_15.xlsx';

/* discover member (DATA) names */
proc datasets lib=xl; quit;

libname xl CLEAR;

Hope this helps