Create multiple tabs with one data step using the xlsx engine

xxformat_com — Mon, 26 Jun 2023 16:59:02 GMT

Hi,

The following code works properly with the excel engine but not with the xlsx engine.

Two data steps are necessary with the xlsx engine.

Is it a bug or an intentional feature (if so what would be the reason)?

%*let xxengine=xlsx;
%let xxengine=excel;

libname demo &xxengine. "&xxtest./reporting/test.xlsx";

data demo.Male
     demo.Female;
    set sashelp.class;
    if sex='M' then output demo.Male;
    else if sex='F' then output demo.Female;
run;

libname demo clear;

Re: Create multiple tabs with one data step using the xlsx engine

Reeza — Mon, 26 Jun 2023 17:19:57 GMT

The error seems to indicate that it's intended at the moment.

74 data demo.Male

75 demo.Female;

76 set sashelp.class;

77 if sex='M' then output demo.Male;

78 else if sex='F' then output demo.Female;

79 run;

ERROR: XLSX libname engine does not support simultaneous output to the same library reference

@xxformat_com wrote:

Hi,

The following code works properly with the excel engine but not with the xlsx engine.

Two data steps are necessary with the xlsx engine.

Is it a bug or an intentional feature (if so what would be the reason)?
%*let xxengine=xlsx;
%let xxengine=excel;

libname demo &xxengine. "&xxtest./reporting/test.xlsx";

data demo.Male
     demo.Female;
    set sashelp.class;
    if sex='M' then output demo.Male;
    else if sex='F' then output demo.Female;
run;

libname demo clear;

topic Re: Create multiple tabs with one data step using the xlsx engine in SAS Programming

Create multiple tabs with one data step using the xlsx engine

Re: Create multiple tabs with one data step using the xlsx engine