Excelling to Another Level with SAS

From sasCommunity
Jump to: navigation, search

Abstract

Have you ever wished that with one click (or submitting one macro call) you could copy any SAS® dataset, include or exclude variable names or labels, automagically create or modify Excel workbooks, or paste tables into files? Or how about doing any of the above but, at the same time, create Pivot Tables and/or, if desired, base new worksheets on existing Excel templates or preformatted workbooks so that you don’t have to spend time duplicating such things as font usage, effects, formulas, highlighting and/or graphs? 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.

Online Materials

Click here to view the paper

Click here to view the macro's tip sheet

Click here to download the SAS code described in this paper

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.

Where

/******************************************
SAS Global Forum 2018
******************************************/

Revision History

Created: August 6, 2013
Most Recent Version: November 10, 2017

Contact Info

art@analystfinder.com User:art297