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 ...