SELECT

SELECT

Selects the items in the access descriptor that are to be included in the view descriptor

Optional statement

Applies to: view descriptor

Syntax
Details

Syntax

SELECT ALL|variable-identifier
<...variable-identifier-n>;

Details

The SELECT statement selects the database items in the access descriptor to be included in the view descriptor.

The SELECT statement can take one or more of the following arguments:

ALL includes in the view descriptor all of the items defined in the access descriptor that were not dropped.

variable-identifier can be the current SAS name, the positional equivalent (which is the number that represents the item as given by the LIST statement), or the SYSTEM 2000 component number of the database item.
For example, if you want to select the first three items, issue the following statement:
select 1 2 3;

You can select as many items as you want using one SELECT statement.

SELECT statements are cumulative within the same view creation. That is, if you submit the following two SELECT statements, items 1, 5, and 6 are selected (not just items 5 and 6):

select 1;
select 5 6;

To clear all of your current selections when creating a view descriptor, you can use the RESET ALL statement; you can then use another SELECT statement to select new items.

Selecting a record selects all items within the record.

Chapter Contents
Previous
Next
Top of Page