The SAS Output Delivery System and reporting techniques

ungroup xlsx worksheets

Reply
New Contributor
Posts: 2

ungroup xlsx worksheets

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

 

Grand Advisor
Posts: 9,748

Re: ungroup xlsx worksheets

I suggest that you show the code used to create them currently used.
New Contributor
Posts: 2

Re: ungroup xlsx worksheets

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 */

Post a Question
Discussion Stats
  • 2 replies
  • 321 views
  • 1 like
  • 2 in conversation