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

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 ...

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