Chapter Contents |
Previous |
Next |
EXTEND |
Optional statement | |
Applies to: | access and view descriptors |
Default | ALL |
Syntax | |
Details |
Syntax |
EXTEND <ALL | VIEW | column-identifier-1 <... column-identifier-n>>; |
Details |
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:
*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.*SELECTED*
. Any columns that are dropped in the access descriptor are
not displayed. The VIEW argument is valid only for a view descriptor.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;
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.