Chapter Contents

Previous

Next
EXTEND

EXTEND



Lists columns in the descriptor and gives information about them.

Optional statement
Applies to: access descriptor or view descriptor


Syntax
Details

Syntax

EXTEND ALL | VIEW | <">column-identifier-1<"> <...<">column-identifier-n<">>;


Details

The EXTEND statement lists information about the DBMS columns in a descriptor. The word *GROUP* is displayed to indicate the existence of a group.

You can use the EXTEND statement when creating an access or a view descriptor. The EXTEND information is written to your SAS log.

You can specify EXTEND as many times as you wish 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 of the DBMS columns in the file, the positional equivalents, the SAS names, the SAS informats, the database contents, the number of occurrences, and the DBMS column types (Alpha or Zoned). 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 SAS names and informats, the database contents, number of occurrences, DBMS column types, any subsetting clauses, and the word *SELECTED*. Any DBMS 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's SAS name, its positional equivalent, its SAS informat, the database content, number of occurrences, DBMS column type, 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 CA-DATACOM/DB field 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 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;

If the column contains special characters or national characters, enclose the name in quotes.


Chapter Contents

Previous

Next

Top of Page

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