White Papers

Creating Multi-Sheet Excel Workbooks the Easy Way With SAS

Overview Transferring SAS data and analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper discusses using the new XML support in Base SAS 9.1 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). The reader will learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain the SAS output. Tips and tricks with the ExcelXP ODS tagset will be divulged.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
SAS Institute
File Format
PDF
Date Published
Jun 2, 2007
Format
White Papers
Topics
Spreadsheets, XML, Programming Languages

Similiar White Papers

Using XML/XSLT as an Alternative to Microsoft Excel

Using XML/XSLT as an Alternative to Microsoft Excel

In CISE, instructors usually maintain student records in Microsoft Excel. This causes serious interoperability and flexi

Publisher: University of Florida  |  Tags: data, excel

SAS Institute White Papers

A Clever Demonstration of the SAS SUBSTR Function

A Clever Demonstration of the SAS SUBSTR Function

The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either s

Publisher: SAS Institute

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

The explosion of customer data in the last twenty years has increased the need for data mining aimed at Customer Relatio

Publisher: SAS Institute  |  Tags: crm, customer service, data, data mining

An Animated Guide: Proc Transpose

An Animated Guide: Proc Transpose

If one can think about a SAS data set as being made up of columns and rows, one can say Proc Transpose "Flips" the colum

Publisher: SAS Institute  |  Tags: data

Cool New Features in SAS Enterprise Miner 5.3

Cool New Features in SAS Enterprise Miner 5.3

SAS released Enterprise Miner 5.3 in late 2007 with a veritable plethora of cool new features for data miners everywhere

Publisher: SAS Institute  |  Tags: data, software

An Introduction to SAS Character Functions

An Introduction to SAS Character Functions

SAS software is especially rich in its assortment of functions that deal with character data. This class of functions is

Publisher: SAS Institute  |  Tags: data, software