The DESCRIBE TABLE Statement
A Brief Overview
Suppose you want to view the table
structure of a table which you or someone else created. The structure
of a table includes the columns and the column attributes. When you
create a table, the CREATE TABLE statement writes a message to the
SAS log, which indicates the number of rows and columns in the table
that was created. However, the message does not contain information
about column attributes.
If you are working with
an existing table that contains rows of data, you can use a PROC SQL
query to generate a report that shows all of the columns in a table.
However, the report does not list the column attributes, and a PROC
SQL query will not generate output for an empty table.
The DESCRIBE TABLE ...
Get SAS Certified Professional Prep Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
