Solved: Stored Process to Excel - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Pyrite | Level 9

Pyrite | Level 9

Stored Process to Excel

Posted 09-22-2011 09:37 PM (1217 views)

Hi,

I got curious with this example. http://support.sas.com/kb/40/683.html

How do you rename the name of the worksheet/s?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

Calcite | Level 5

Calcite | Level 5

Stored Process to Excel

Posted 09-23-2011 04:01 AM (1397 views) | In reply to milts

Use this Option

ods tagsets.ExcelXP options(sheet_name='Sheet Name Here');

View solution in original post

2 REPLIES 2

Calcite | Level 5

Calcite | Level 5

Stored Process to Excel

Posted 09-23-2011 04:01 AM (1398 views) | In reply to milts

Use this Option

ods tagsets.ExcelXP options(sheet_name='Sheet Name Here');

Pyrite | Level 9

Pyrite | Level 9

Stored Process to Excel

Posted 09-25-2011 11:44 PM (1165 views) | In reply to RSB

Hi,

Thanks for the help! I used TAGSETS.MSOFFICE2K instead because I was getting an error with EXCELXP. I couldn't open the file.