Using ODS Tagsets - How do name the tabs within a workbook

[deleted_user]

I have a project that requires me to put all 50 states in one workbook with each tab respresenting a state. I would like to name the tabs in my workbook. How do I do that. I am think a Macro that is called to label the tabs, but I am not sure how to name the tabs in the first place.

[Cynthia_sas]

Hi:
Look at the example of the SHEET_NAME option in this Tech Support note:
http://support.sas.com/kb/33/564.html

cynthia

[SASKiwi]

In addition to Cynthia's suggestion, have a look at:

ods tagsets.excelxp
options ( SHEET_NAME = 'STATE' SHEET_INTERVAL = 'BYGROUP')
;

If your data is sorted in state order and you do your report using a BY statement then the above will automatically create a new tab/worksheet for each state and will append a number on the end of the sheet name. This is a very easy technique to produce a multi-tab Excel workbook.