A Poor/Rich SAS Users Proc Export

From sasCommunity
Jump to: navigation, search


Have you ever wished that with one click you could copy any SAS® dataset, including variable names or labels (if desired), and automagically create or modify an Excel workbook, or paste the table into a Word file or Powerpoint presentation? Or, when accomplishing such a task, have you ever wished that you could take advantage of Excel templates, or choose whether you want to export formatted or unformatted values? You can and, with just base SAS, there are some little known but easy to use methods that are available for automating many of your (or your users') common tasks.


We've made so many enhancements to the macro that we decided that it's re-write deserved its own paper. SGF agreed and the revised macro will be presented at SGF 2018 in Denver. The new macro can be found at: http://www.sascommunity.org/wiki/Excelling_to_Another_Level_with_SAS

Online Materials

Powerpoint Presentation

The presentation is shown in the box, below, but the behavior is different for different browsers. With Chrome, the pdf menu will appear if you move your pointer to the lower part of the box. Click on the menu's far left item, then you can PgDn through the presentation. Also, with Chrome's menu, one of the icons will let you save the file so that you can open it, directly, using the free Adobe Reader. With Explorer the menu appears if you move your pointer toward the upper part of the box, but is only needed if you want to save the pdf. With Firefox, clicking the >> symbol at the upper-righthand corner of the box lets you save the file.

When and Where

Date: Wednesday, March 26, 2014 (SGF)
Time: 11:30am-11:50am
Where: National Harbor 4 Theater 136

Revision History

Created: August 6, 2013
Most Recent Version: January 8, 2015

Contact Info

art@analystfinder.com User:art297