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 Statement for more information
about 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
that you are creating.
The EXTEND statement
can take one of the following arguments:
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.
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.
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 quotation marks.
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;