Reading in external data into a SAS dataset

In this training module we will cover the following topics:

–   How to read in an Excel (.xls) file into a SAS dataset

–   How to read in an ASCII (.txt) file into a SAS dataset

In this module we will learn how to read in an Excel (.xls) file into a SAS dataset using PROC IMPORT. We will also look at how to read in an ASCII (.txt) file into a SAS dataset using the INFILE and INPUT statements, as well as cover some essential SAS dataset options that help us to achieve this.