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

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