| Publisher | SAS Institute | ||
|---|---|---|---|
| Format | 529.8KB PDF | Date added | 14 May 2007 |
| Topics | Knowledge and Data Management, Programming Languages, Spreadsheets | ||
| Downloads | 515 | ||
This paper provides several enhancements to a technique that uses Base SAS and Visual Basic Scripting to automate the creation of Excel Pivot Tables from SAS data sets. The earlier paper presented at SUGI 31 consisted of a macro that produced a delimited file from a SAS data set and then created several pivot tables from the delimited file. The macro worked fine and produced the desired results. The author rewrote the macro and included several enhancements which are mentioned in the paper.
Did you find this white paper useful?
22 out of 50 users found this white paper useful
Related white papers
Maxmise IT Flexibility and Lower Costs With Grid Computing
This document discusses grid computing: Oracle's definition of it, the benefits of it, and the elements that comprise an Oracle Enterprise Grid Computing environment. It also highlights an Oracle customer's...
Ten Things to Know About Grid Computing on Windows
This Oracle whitepaper offers insights into Oracle Grid. A grid allows a business to add capacity, cheaply, whenever it is needed. What's more, an Oracle Grid can help you gain control...
The ROI of Data Governance - A Revenue Generation Perspective
"Concentrating on increasing revenue necessarily means paying attention to metrics such as return on investment (ROI). This white paper from Gwen Thomas of the Data Governance Institute provides a practical...
Building a Data Quality Scorecard for Operational Data Governance
" Operational data governance is the manifestation of the processes and protocols necessary to ensure that an acceptable level of confidence in the data effectively satisfies the organization's business needs....
MDM Components and the Maturity Model
Any effective master data management program requires a mix of technologies to achieve success. This white paper by David Loshin provides a conceptual outline of technical MDM components and examines...
Ovum Report: IBM Simplfies Service Management to facilitate business and IT
All too often, companies find their IT infrastructure is fragmented and confused. Different parts of the business have different silos of data and applications, with no integrated vision joining them...
Massively Scalable NAS - Pre-Empting Tomorrow's Data Overload with Today's Technology
HP is launching the HP StorageWorks 9100 Extreme Data Storage System that solves challenges such as extreme scability, manageability and affordability and creates new business opportunities. HP is going to...
