Exchanging Data between SAS and Microsoft Excel

Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently

Master simple-to-complex techniques for transporting and managing data between SAS and Excel
William Benjamin’s Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently describes many of the options and methods that enable a SAS programmer to transport data between SAS and Excel. The book includes examples that all levels of SAS and Excel users can apply to their everyday programming tasks. Because the book makes no assumptions about the skill levels of either SAS or Excel users, it has a wide-ranging application, providing detailed instructions about how to apply the techniques shown. It contains sections that gather instructional and syntactical information together that are otherwise widely dispersed, and it provides detailed examples about how to apply the software to everyday applications. These examples enable novice users and power developers alike the chance to expand their capabilities and enhance their skillsets.
By moving from simple-to-complex applications and examples, the layout of the book allows it to be used as both a training and a reference tool. Excel users and SAS programmers are presented with tools that will assist in the integration of SAS and Excel processes in order to automate reporting and programming interfaces. This enables programming staff to request their own reports or processes and, in turn, support a much larger community.

Table of Contents

Chapter 1: Easy Data Movement between SAS and Microsoft Excel
Chapter 2: Use PROC EXPORT to Write SAS Data to External Files and Excel Workbooks
Chapter 3: Use PROC IMPORT to Read External Data Files and Excel Workbooks into SAS
Chapter 4: Using the SAS LIBNAME to Process Excel Files
Chapter 5: SAS Enterprise Guide Methods and Examples
Chapter 6: Using JMP to Share Data with Excel
Chapter 7: SAS Add-In for Microsoft Office (Excel)
Chapter 8: Creating Output Files with ODS for Use by Excel
Chapter 9: Accessing Excel with OLE DB or ODBC Application Program Interfaces (API Methods)
Chapter 10: Using PROC SQL to Access Excel Files
Chapter 11: Using DDE to Read and Write to Excel Workbooks
Chapter 12: Building a System of Excel Macros Executable by SAS
Chapter 13: Building a System of Microsoft Windows Scripts to Control Excel Macros
Chapter 14: Create an Excel Workbook That Runs SAS Programs