Learning SAS by Example

Chapter 6: Reading and Writing Data from an Excel Spreadsheet

6.1  Introduction

6.2  Using the Import Wizard to Convert a Spreadsheet to a SAS Data Set

6.3  Creating an Excel Spreadsheet from a SAS Data Set

6.4  Using an Engine to Read an Excel Spreadsheet

6.5  Using the SAS Output Delivery System to Convert a SAS Data Set to an Excel Spreadsheet

6.6  A Quick Look at the Import Utility in SAS Studio

6.7  Problems

 

6.1  Introduction

It is quite common to be given a Microsoft Office Excel spreadsheet as your data source. Luckily, SAS has several methods to easily convert a spreadsheet into a SAS data set. One way is to convert the spreadsheet into a comma-separated values (CSV) file and to read the file using INFILE statements (using the DSD ...