Selects the items in the access descriptor that are to be included
in the view descriptor
|| view descriptor
SELECT ALL | item-name | index-number <...
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.
The following list explains the arguments
that appear in the SELECT statement:
- includes in the view descriptor all of the
items that are defined in the access descriptor that were not dropped.
- If the access descriptor contains segments representing more than
one path, using ALL will create an invalid view descriptor.
- 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.
- 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.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.