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
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.