Skip to Main Content
An Introduction to SAS University Edition
book

An Introduction to SAS University Edition

by Ron Cody
February 2018
Beginner content levelBeginner
366 pages
7h 2m
English
SAS Institute
Content preview from An Introduction to SAS University Edition

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Essential Statistics Using SAS University Edition

Essential Statistics Using SAS University Edition

Geoff Der, Brian S. Everitt
Elementary Statistics Using SAS

Elementary Statistics Using SAS

Sandra D. Schlotzhauer

Publisher Resources

ISBN: 9781629600079