The SAS Output Delivery System and reporting techniques

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

Reply
N/A
Posts: 0

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

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.
SAS Super FREQ
Posts: 8,868

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

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

cynthia
Super User
Posts: 3,260

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

Posted in reply to Cynthia_sas
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.
Ask a Question
Discussion stats
  • 2 replies
  • 166 views
  • 0 likes
  • 3 in conversation