cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
AmberLOL
Calcite | Level 5 AmberLOL
Calcite | Level 5

How to auto exporting pivot table to excel without clicking the button on HTML?

Posted 04-07-2015 11:55 AM (1818 views)

Hi All,

I want to auto export the pivot table and creating a new excel file at the same time, but do not use the step of HTML.

Is there a way to realize it? Could you provide a sample code ? Thank you. Smiley Happy

0 Likes
Reply
1 REPLY 1
ChrisHemedinger
Community Manager ChrisHemedinger
Community Manager

Re: How to auto exporting pivot table to excel without clicking the button on HTML?

Posted 04-07-2015 12:38 PM (1705 views)  |   In reply to AmberLOL

Check out 's recent article about this:

http://blogs.sas.com/content/sgf/2015/03/27/using-sas-to-add-pivottables-to-your-excel-workbook/

Chris

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
0 Likes
Reply

sas-innovate-2026-white.png



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!

Register now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Watch Creating Custom Steps in SAS Studio on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • ‎04-07-2015 11:55 AM
  • 1819 views
  • 0 likes
  • 2 in conversation