topic Re: ungroup xlsx worksheets in ODS and Base Reporting

ungroup xlsx worksheets

gdsilva — Wed, 20 Apr 2016 18:06:25 GMT

When creating multiple worksheets in ODS excel (SAS9.4) the worksheets are grouped by default.

The user of the XLSX has to ungroup them manually.

How does one create ungrouped XLSX work sheets in ODS Excel

regards

gdsilvs

Re: ungroup xlsx worksheets

ballardw — Wed, 20 Apr 2016 22:18:20 GMT

I suggest that you show the code used to create them currently used.

Re: ungroup xlsx worksheets

gdsilva — Thu, 21 Apr 2016 13:17:13 GMT

data abc;

label sex="sex";

a=1;b=1;sex='M'; output;

a=1;b=1;sex='F';output;

run;

proc sort ; by sex;

ods excel file="/usr/sas/work/sas/SAS_workgran.xlsx"

options

(sheet_interval='bygroups' suppress_bylines='no'

sheet_name='#byval(sex)'

);

proc report data=abc; by sex;

run;

ods excel close;

/* when the file SAS_workgran.xlsx is opened the worksheets are grouped */

Re: ungroup xlsx worksheets

Tom — Thu, 20 Jul 2017 13:54:34 GMT

Does anyone have 9.4 TS1M4 to see if this is fixed in that version?

According to this page http://support.sas.com/kb/56/878.html it should be fixed, but I do not have access to that version to test.

Re: ungroup xlsx worksheets

Vince_SAS — Fri, 21 Jul 2017 12:16:30 GMT

This problem is corrected in the fourth maintenance release for SAS 9.4. If you need a hotfix for SAS 9.4 M3, click the "Hot Fix" tab in the link that Tom provided.

Vince DelGobbo

SAS R&D