Rename multiple excel worksheet names

DME790 — Tue, 29 Aug 2017 23:53:35 GMT

Hi All,

I have multiple Proc Tabulates that I export out to excel workbook and I need to be able to five each worksheet a meaningful name.

I have used the ODS EXCEL option of sheet_name that names the first sheet to 'Entered' - how do I now assign names to the other worksheets?

ods excel file="/sasdata/OTH_Baselining.xlsx" options(Embedded_Titles='yes'
Embedded_footnotes='YES' sheet_name='Entered');
ods escapechar="^";
Title1 font=Arial BOLD "Other Business Line Baseline";
Title2 font=Arial BOLD "01January 2017 to 20 August 2017";



Proc Tabulate data=work.Other_Baseline_SUM format=comma9.0 out=work.Other_Baseline_2;
	*/
	where Event_DT >= '01Jul2016'd;
	class Queue_type CLUSTER SDOCLUSTERPBS QUEUE_CD;
	VAR CALLS_Entered_CNT;

	Table 
		Queue_type = "" * Cluster = "" * SDOCLUSTERPBS = "" * queue_cd
		,CALLS_Entered_CNT="" * sum
		/ box= "Entered Calls"
	;
run;


Proc Tabulate data=work.Other_Baseline_SUM format=comma9.0 out=work.Other_Baseline_2;
	*/
	where Event_DT >= '01Jul2016'd;
	class Queue_type CLUSTER SDOCLUSTERPBS QUEUE_CD;
	VAR CALLS_Answered_CNT;

	Table 
		Queue_type = "" * Cluster = "" * SDOCLUSTERPBS = "" * queue_cd
		,CALLS_Answered_CNT="" * sum
		/ box= "Entered Calls"
	;
run;

Title1;
title2;
ODS EXcel close;

Regards

Dean

Re: Rename multiple excel worksheet names

DME790 — Wed, 30 Aug 2017 00:47:39 GMT

I have used ODS excel options(sheet_name='XXXXX'); before each Proc Tabulate statement to rename the worksheet - this seems to be working for me.

Cheers

Dean

topic Rename multiple excel worksheet names in SAS Enterprise Guide

Rename multiple excel worksheet names

Re: Rename multiple excel worksheet names