O'Reilly logo

An Introduction to SAS University Edition 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 8: Reading Data from External Files

Introduction

Reading Data Values Separated by Delimiters

Reading Comma-Separated Values Files

Reading Data Separated by Other Delimiters

Reading Data in Fixed Columns

Column Input

Formatted Input

Reading Excel Files

Reading from an Excel Workbook where Column Headings Are Invalid SAS Variable Names

Conclusion

Problems

Introduction

This chapter describes three of the most common methods that you can use to read raw text data using SAS. It also demonstrates how to create SAS data sets from Excel workbooks. If you typically receive data that is already in SAS data sets, you can skip this chapter (unless you are just curious).

Reading Data Values Separated by Delimiters

One common method of storing data ...

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