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;
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.