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

[Ronein]

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;

[SASKiwi · Accepted solution]

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.