Biostatistics by Example Using SAS Studio

Chapter 4: Reading Data from Text Files

Introduction

Understanding the Work Area

Some Basic Rules of SAS Programs

Writing a Program to Read a Text File Where Data Values Are Separated by Delimiters

Viewing Errors and Warnings

Reading CSV Files

Reading Text Files with Other Delimiters

Setting the Length of Character Variables

Reading Text Data in Fixed Columns

Conclusions

Problems

Introduction

You may have data in text files, either separated by delimiters or arranged in columns. In order to import data of this type, you will need to write a SAS program. Don't panic. It's not that hard to do, and at some point in your education, you may need to go beyond what the SAS Studio point-and-click environment can do for you.

If your data is in one of ...