Exchanging Data between SAS and Microsoft Excel

Chapter 12: Building a System of Excel Macros Executable by SAS

12.1 Introduction

12.2 Purpose

12.3 General Design of a Tool to Control Excel Macros from SAS

12.3.1 Prepare a SAS File and Execute Excel to Process the Output

12.3.2 Prepare Excel to Open the File Output by SAS

12.3.3 Prepare Excel Macros to Reformat the Excel Workbooks

12.4 Automate the Tool So That SAS Creates a Formatted Excel Output Workbook

12.4.1 Eliminate the Manual Steps from the Processing

12.4.2 Create a SAS Output File with More Data and Control Information

12.4.3 Create an Excel Macro to Process the Output SAS File

12.4.4 Build an Excel Graph Using an Excel Macro

12.5 Conclusion

12.1 Introduction

Chapters 12, 13, and 14 each define separate, but increasingly powerful ...