Displays a PROC SQL definition in the SAS
log.
DESCRIBE
TABLE table-name <,table-name>... ;
|
DESCRIBE VIEW proc-sql-view
<,proc-sql-view>... ;
|
DESCRIBE TABLE CONSTRAINTS table-name <,
table-name>... ;
|
- table-name
- specifies a PROC SQL table.
- proc-sql-view
- specifies a PROC SQL view.
- The DESCRIBE TABLE statement writes a CREATE TABLE statement to
the SAS log for the table specified in the DESCRIBE TABLE statement, regardless
of how the table was originally created (for example, with a DATA step). If
applicable, SAS data set options are included with the table definition. If
indexes are defined on columns in the table, CREATE INDEX statements for those
indexes are also written to the SAS log.
When you are transferring a table to a DBMS that is supported by SAS/ACCESS
software, it is helpful to know how it is defined. To find out more information
on a table, use the FEEDBACK option or the CONTENTS statement in the DATASETS
procedure.
- The DESCRIBE VIEW statement writes a view definition to the SAS
log. If you use a PROC SQL view in the DESCRIBE VIEW statement that is based
on or derived from another view, you may want to use the FEEDBACK option in
the PROC SQL statement. This option displays in the SAS log how the underlying
view is defined and expands any expressions that are used in this view definition.
The CONTENTS statement in DATASETS procedure can also be used with a view
to find out more information.
- The DESCRIBE TABLE CONSTRAINTS statement lists the integrity constraints
that are defined for the specified table(s).
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.