An Introduction to SAS University Edition

Chapter 3: Importing Your Own Data

Introduction

Exploring the Utilities Tab

Importing Data from an Excel Workbook

Listing the SAS Data Set

Importing an Excel Workbook with Invalid SAS Variable Names

Importing an Excel Workbook That Does Not Have Variable Names

Importing Data from a CSV File

Conclusion

Introduction

In the last chapter, you saw how to use some of the features of SAS Studio to manipulate data from the built-in SAS data sets in Sashelp. In this chapter, you will see how easy it is to import your own data from Excel workbooks, CSV files, and many other file formats such as Access and SPSS to create SAS data sets.

Exploring the Utilities Tab

If you open up your Tasks tab in the navigation pane, you will see the following:

Figure 3.1: ...