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