XLSX libname engine to export multiple data sets into multiple xlsx files

Ronein — Sun, 27 Mar 2022 20:00:10 GMT

Hello

I want to export multiple data sets into multiple XLSX files.

I want to save the XLSX files in specific path (and folder name).

My question: In the code below I am writing 3 times libname.

Is it possible to export these 3 data sets into 3 xlsx files by writing only one libname?

Libname RRR XLSX   '/path/SAS_Into_XLSX_folder/cars.xlsx'
Data RRR.cars;
Set sahelp.cars;
Run;

Libname RRR XLSX   '/path/SAS_Into_XLSX_folder/Class.xlsx'
Data RRR.Class;
Set sashelp.Class;
Run;

Libname  RRR XLSX   '/path/SAS_Into_XLSX_folder/baseball.xlsx'
Data RRR.Class;
Set sashelp.baseball;
Run;

Re: XLSX libname engine to export multiple data sets into multiple xlsx files

SASKiwi — Sun, 27 Mar 2022 21:18:01 GMT

The XLSX engine in the SAS LIBNAME statement must reference a single Excel workbook. If you want to write to three different workbooks as is the case in your example, then you must use three LIBNAME statements. If on the other hand you want to write three SAS datasets to one Excel workbook then only one LIBNAME statement is required.

topic XLSX libname engine to export multiple data sets into multiple xlsx files in SAS Programming

XLSX libname engine to export multiple data sets into multiple xlsx files

Re: XLSX libname engine to export multiple data sets into multiple xlsx files