The ACCESS Procedure for Relational Databases RENAME Statement 303
Details
The LIST statement lists columns in the descriptor, along with information about the
columns. The LIST statement can be used only when creating an access descriptor or a
view descriptor. The LIST information is written to your SAS log.
Note: To review the contents of an existing view descriptor, use the CONTENTS
procedure.
When you use LIST for an access descriptor,
*NON-DISPLAY*
appears next to the
column description for any column that has been dropped;
*UNSUPPORTED* appears
next to any column whose data type is not supported by your DBMS interface view
engine. When you use LIST for a view descriptor,
*SELECTED* appears next to the
column description for columns that you have selected for the view.
Specify LIST last in your PROC ACCESS code in order to see the entire descriptor. If
you are creating or updating multiple descriptors, specify LIST before each CREATE or
UPDATE statement in order to list information about all of the descriptors that you are
creating or updating.
QUIT Statement
Terminates the procedure
Applies to:
access descriptor or view descriptor
QUIT;
Details
The QUIT statement terminates the ACCESS procedure without any further
descriptor creation. Changes made since the last CREATE, UPDATE, or RUN
statement are not saved; changes are saved only when a new CREATE, UPDATE, or
RUN statement is submitted.
RENAME Statement
Modifies the SAS variable name
Applies to: access descriptor or view descriptor
Interacts with: ASSIGN, RESET
RENAME <’>column-identifier-1<’> <=> SAS-variable-name-1
<…<’>column-identifier-n<’> <=> SAS-variable-name-n>;
