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 (1757 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 (1644 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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1758 views
  • 0 likes
  • 2 in conversation