University of Southern California

ITS Information Technology Services

A division of the Office of the Chief Information Officer

Opening & Editing SAS datasets

SAS Explorer with Dataset

This document will show you how to open and edit your SAS datasets.

Opening SAS Datasets

To open your desired SAS dataset, you will first need to open the SAS library that contains your dataset. Double-click the library's icon in the Explorer window. The will show the contents of the SAS library you selected. In the window on the right, the library has only one dataset, Internet.

Notice the SAS dataset icon. According to SAS, this is what a dataset looks like. Other SAS applications such as Analyst, Graph N Go and other point-and-click features will also use this icon to represent a SAS dataset.

To open the dataset, double-click the dataset icon.

Browse is the default mode for the table view. In Browse mode you can scroll up and down to look at the data and, from the Edit menu, you can select Find to find specific values in the dataset.

Editing SAS Datasets

To edit a dataset, from the Edit menu, select Edit mode. In Edit mode you can add rows, delete rows and change specific values.

SAS dataset view

For example, in the dataset above, to change the value for EnrolledMember from "Yes" to "Y", you would select Edit Mode from the File menu. Once in Edit mode, click the cell you wish to change and type the new value.

To delete a row, you must be in Edit Mode, click on the row to select it and, from the Edit menu, select Delete row.

Last updated:
February 24, 2010

SAS

The use of all USC computing resources is governed by the USC Computing Policies.