O'Reilly logo

Learning SAS by Example by Ron Cody

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Reading and Writing Data from an Excel Spreadsheet

6.1

Introduction

87

6.2

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

88

6.3

Creating an Excel Spreadsheet from a SAS Data Set

93

6.4

Using an Engine to Read an Excel Spreadsheet

95

6.5

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

96

6.6

Problems

98

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 option—see Chapter 3 for more information) and INPUT statements. However, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required