Lists columns in the descriptor and gives information about them.
|
Optional statement
|
| Applies to: |
access and view descriptors
|
| Default |
ALL
|
EXTEND <ALL | VIEW |column-identifier-1
<...
column-identifier-n>>;
|
The EXTEND statement lists information about the informat,
DB content, occurrence range, descriptor type, and BY key columns in the descriptor.
For groups and periodic groups, *GROUP* or *PGROUP* is displayed, respectively.
You can use the EXTEND statement when creating an access
or a view descriptor. The EXTEND information is written to your SAS log.
If you use an editing statement, such as EXTEND, it
must follow the CREATE statement and the database-description statements when
you create a descriptor. See CREATE
for more information on the order of statements.
You can specify EXTEND as many times as you want while creating a descriptor;
specify EXTEND last in your PROC ACCESS code to see the completed descriptor
information. Or, if you are creating multiple descriptors, specify EXTEND
before the next CREATE statement to list all the information about the descriptor
you are creating.
The EXTEND statement can take one of the following arguments:
-
ALL
-
lists all the DBMS columns in the file,
the positional equivalents, the two-character ADABAS names, the SAS
variable informats, the database contents, occurrence ranges, descriptor types,
and BY keys that are available for the access descriptor. When you are creating
an access descriptor,
*NON-DISPLAY* appears next to the
column description for any column that has been dropped. When you are creating
a view descriptor,
*SELECTED* appears next to the column
description for columns that you have selected for the view.
-
VIEW
-
lists all the DBMS columns that are selected
for the view descriptor, along with their positional equivalents, their two-character
ADABAS names, their SAS variable informats, the database contents, occurrence
ranges, descriptor types, BY keys, any subsetting clauses, and the word
*SELECTED*. Any columns that are dropped in the access descriptor are
not displayed. The VIEW argument is valid only for a view descriptor.
-
column-identifier
-
lists the specified DBMS column name, its
positional equivalent, its two-character ADABAS name, its SAS variable
informat, the database content, occurrence range, descriptor type, BY keys
that are available for the access descriptor, and whether the column has been
selected or dropped. If the column name contains special characters or national
characters, enclose the name in quotes.
The column-identifier argument can be either
the column name, the positional equivalent from the LIST statement, which
is the number that represents the column's place in the descriptor, or a list
of column names or positions. For example, to list information about the
fifth column in the descriptor, submit the following statement:
extend 5;
Or, to list information about the fifth, sixth, and
eighth columns in the descriptor, submit the following statement:
extend 5 6 8;
Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
