O'Reilly logo

SAS 9.4 Language Reference, 6th Edition by SAS Institute

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 17
Managing Your Data in the SAS
Windowing Environment
Introduction to Managing Your Data in the SAS Windowing Environment . . . . 376
Managing Data with SAS Explorer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 376
Introduction to Managing Data with SAS Explorer . . . . . . . . . . . . . . . . . . . . . . . . 376
Viewing Libraries and Data Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 376
Assign File Shortcuts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 378
Rename a SAS Data Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 378
Copy or Duplicate a SAS Data Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 379
Sorting Data Sets in a Library . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 379
View the Properties of a SAS Data Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 379
Working with VIEWTABLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 380
Overview of VIEWTABLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 380
Opening a SAS Data Set in a VIEWTABLE Window . . . . . . . . . . . . . . . . . . . . . . 380
Displaying Table Headers as Names or Labels . . . . . . . . . . . . . . . . . . . . . . . . . . . 382
Customizing SAS Explorer for Opening the VIEWTABLE Window . . . . . . . . . . 383
Order of Precedence for How Column Headings Are Displayed . . . . . . . . . . . . . . 384
Mapping the VIEWTABLE Command to a Function Key . . . . . . . . . . . . . . . . . . . 384
Temporarily Change Column Headings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 385
Move Columns in a Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 386
Sort by Values of a Column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 387
Edit Cell Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 389
Subsetting Data By Using the WHERE Expression . . . . . . . . . . . . . . . . . . . . . . . . 390
Subset Rows of a Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 390
Clear the WHERE Expression . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 392
Exporting a Subset of Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 393
Overview of Exporting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 393
Export Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 393
Importing Data into a Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 396
Overview of Importing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 396
Import a Standard File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 396
Import a Nonstandard File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 398
375

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