Chapter 25
SAS Data Sets
Definition of a SAS Data Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 591
Descriptor Information for a SAS Data Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 592
Data Set Names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 594
Where to Use Data Set Names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 594
How and When SAS Data Set Names Are Assigned . . . . . . . . . . . . . . . . . . . . . . . 594
Parts of a Data Set Name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 594
Two-level SAS Data Set Names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 595
One-level SAS Data Set Names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 595
Data Set Lists . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 596
Special SAS Data Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 597
Null Data Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 597
Default Data Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 597
Automatic Naming Convention . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 597
Sorted Data Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 598
The Sort Indicator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 598
How SAS Uses the Sort Indicator to Improve Performance . . . . . . . . . . . . . . . . . 603
Validating That a Data Set Is Sorted . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 603
Tools for Managing Data Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 604
Viewing and Editing SAS Data Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 604
Definition of a SAS Data Set
A SAS data set is a SAS file stored in a SAS library that SAS creates and processes. A
SAS data set contains data values that are organized as a table of observations (rows)
and variables (columns) that can be processed by SAS software. A SAS data set also
contains descriptor information such as the data types and lengths of the variables, as
well as which engine was used to create the data.
A SAS data set can be one of the following:
SAS data file
contains both the data and the descriptor information. SAS data files have a member
type of DATA. For specific information, see Chapter 26, “SAS Data Files,” on page
605.
591