Exchanging Data between SAS and Microsoft Excel

Preface

Over time, I have learned that, to keep life simple, you give the boss data in the format he or she wants. In other words, if the boss wants an Excel workbook, you deliver an Excel workbook with all the data and formatting requested. If the data comes from Excel, you need to find a way to read the data from the Excel files. For this book, I wrestled with the question of how to describe merging the SAS and Excel distinct skill sets in a way that would be understandable to both groups. This book is primarily written for people who need to transfer data between SAS and Excel. That usually means that you are well-versed in one application, but not the other. My choice of words was very careful when I used the word “BETWEEN.”

I have included ...