topic ODS EXCEL in SAS Programming

ODS EXCEL

SASMom2 — Mon, 13 Jan 2025 05:14:45 GMT

Hello, I need some help. I have 8 tables/datasets in SAS that I want to export to Excel using ODS Excel. They all need to go in one excel file with three tabs. Out of these 8 tables, 4 need to go in the 1st tab, two in the 2nd tab and last two need to go in the 3rd tab. I know how to have either all tables in one tab (using sheet_interval='NONE') or have all the tables in a separate tab (using sheet_interval='YES') but I do not know how to accomplish what I need to do.

I appreciate your help.

Thank you

Re: ODS EXCEL

Ksharp — Mon, 13 Jan 2025 06:13:27 GMT

ods excel file='c:\temp\temp.xlsx' options(sheet_name='First Tab' sheet_interval='none');
/*First table*/
proc print data=sashelp.class;run;
/*Second table*/
proc print data=sashelp.class;run;

ods excel options(sheet_name='Second Tab' sheet_interval='proc');
/*Third table*/
proc print data=sashelp.class(obs=4);run;
ods excel options(sheet_interval='none');
/*Fourth table*/
proc print data=sashelp.class(obs=4);run;

ods excel options(sheet_name='Third Tab' sheet_interval='proc');
/*Fifth table*/
proc print data=sashelp.class(obs=8);run;
ods excel options(sheet_interval='none');
/*Sixth table*/
proc print data=sashelp.class(obs=8);run;

ods excel close;

Re: ODS EXCEL

SASMom2 — Tue, 14 Jan 2025 02:51:36 GMT

Thank you for your help! It worked beautifully!