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 (1395 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 (1575 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 (1576 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 (1343 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.

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!