libname XLSX

Ronein — Mon, 03 Feb 2025 20:30:17 GMT

Hello

Why Do I get error here?

Should I always write the XLSX file name in the path?

(When I export into sas data set and not XLSX file then I dont write the data set name in the path ...)

ERROR: File RON.EX3.DATA does not exist.

libname Ron clear;
libname Ron XLSX "/usr/local/SAS/SASUsers/LabRet/UserDir/Udclk79/Targilim/";
data Ron.EX3;
set sashelp.cars;
run;

and here it is working well with no error

libname Ron clear;
libname Ron  "/usr/local/SAS/SASUsers/LabRet/UserDir/Udclk79/Targilim/";
data Ron.EX3;
set sashelp.cars;
run;

Note-

Here are some examples



/***WAY1--Create XLSX file  called EX1 with one sheet called EX1***/
libname Ron clear;
libname Ron XLSX "/usr/local/SAS/SASUsers/LabRet/UserDir/Udclk79/Targilim/EX1.xlsx";

data Ron.EX1;
set sashelp.cars;
run;


/***WAY2--Create XLSX file  called EX2with one sheet called MySheet***/
libname Ron clear;
libname Ron XLSX "/usr/local/SAS/SASUsers/LabRet/UserDir/Udclk79/Targilim/EX2.xlsx";
data Ron.MySheet;
set sashelp.cars;
run;


/***WAY3--Create XLSX file  called EX3**/
/**Not work !!error***/
libname Ron clear;
libname Ron XLSX "/usr/local/SAS/SASUsers/LabRet/UserDir/Udclk79/Targilim/";
data Ron.EX3;
set sashelp.cars;
run;

/**Work well**/
libname Ron clear;
libname Ron  "/usr/local/SAS/SASUsers/LabRet/UserDir/Udclk79/Targilim/";
data Ron.EX3;
set sashelp.cars;
run;

Re: libname XLSX

Tom — Mon, 03 Feb 2025 20:38:42 GMT

The BASE SAS libref engine need to be pointed to a directory. It will create/look for files with .sas7bdat extension in that directory.

The XLSX libref engine needs to be pointed to a FILE. It will create/look for worksheets within that file.

Re: libname XLSX

ChrisHemedinger — Mon, 03 Feb 2025 21:37:36 GMT

Think of the XLSX file as a "folder" for data sets, and each sheet is a data set within that folder. The XLSX engine (like the JSON engine, XML engine and others) can work with a collection of "data tables" within one actual file.

topic Re: libname XLSX in SAS Programming

libname XLSX

Re: libname XLSX

Re: libname XLSX