|
Taking Full Advantage of SAS® Seamless Integration with Microsoft's Office Suite |
|
Paper 004-2007: Compson, Michael L. Hennessey, John C
The Office of Policy (OP) in the Social Security Administration (SSA) produces a series of publications containing programmatic statistical estimates. In any given year, OP produces approximately 1,425 tables, most of which are generated using Microsoft Excel (MS-EXCEL). In 2005, OP decided to undertake a major project to evaluate the consistency of its statistical estimates and all the accompanying formats and documentation of the tables. Given the sheer magnitude of the number of tables produced, it was decided to use SAS to create metadata for the most recently available tables. The cooperation between SAS and the Microsoft Office Suite allows users to move between SAS and various programs within the Suite. The ability to move between SAS, MS-EXCEL, and Microsoft ACCESS (MS-ACCESS), plus the strong technical support from SAS has allowed OP to systematically evaluate the consistency and accuracy of all aspects of their publications.
 How Suite It Is – Taking Full Advantage of SAS® Seamless Integration with Microsoft's Office Suite
|
|
|
Good Info Comes in Small Multiples – Creating Small Multiple Presentations of Data with SAS® and Exc |
|
Conway, Ted, SAS Global Forum 1007
Promoted by folks like visualization guru Edward Tufte, the use of small multiple presentations of data in charts or
other forms to visualize information is rapidly gaining traction. Unfortunately, creating a large number of Excel Bar
and Line Charts to present your summarized SAS data can be surprisingly labor intensive. This paper presents a
technique and macro that combine Base SAS with Visual Basic Scripting to make it possible to automate the creation
of “small multiples” in the form of Excel Bar and Line Charts to present information gleaned from SAS data sets.
Good Info Comes in Small Multiples – Creating Small Multiple Presentations of Data with SAS® and Exc
|
|
|
How to Generate 10,000 Excel Spreadsheets in 10 Minutes (Or Less) |
|
Churchill, Alan K. - SAS Global Forum 2007
SAS programmers have traditionally used techniques such as proc export, DDE, Access to PC File Formats, excel libname engine, and ODS to generate Excel spreadsheets. Each one of these approaches, though, focuses on „pushing the data (Excel spreadsheets) from SAS.
A new .NET „pull technique is presented in this paper. This technique „pulls the data from SAS and creates Excel spreadsheets from a dedicated Excel model. This approach allows for full customization of Excel spreadsheets including formatting, calculations, printing styles, etc. using SAS datasets. In addition, native Excel spreadsheets are generated. This approach, by being a native .NET application, is an amazingly fast way of generating Excel spreadsheet and it overcomes many of the limitations seen in the past.
How to Generate 10,000 Excel Spreadsheets in 10 Minutes (Or Less)
|
|
|
Microsoft Excel Integration 
