Chapter Contents

Previous

Next
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
Arguments

Syntax

SELECT ALL | item-name | index-number <... item-name-n|index-number-n>;


Details

The SELECT statement selects the items in the access descriptor that are to be included in the view descriptor. Use the SELECT statement only when you are defining view descriptors. You can select as many items as necessary using one SELECT statement.


Arguments

The following list explains the arguments that appear in the SELECT statement:

ALL
includes in the view descriptor all of the items that are defined in the access descriptor that were not dropped.
CAUTION:
If the access descriptor contains segments representing more than one path, using ALL will create an invalid view descriptor.   [cautionend]

item-name
specifies the name of the item you want to select to be included in the view descriptor. If you specify a record or group name, all the items in that record or group are selected.

index-number
specifies the index number of the item you want to select. The index number represents the item's place in the access descriptor. You can get the index number of an item using the LIST statement described earlier in this section. If you specify a record or group index number, all the items in that record or group are selected.


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.