Create multiple tabs with one data step using the xlsx engine

[xxformat_com]

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;

[Reeza]

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;

---