Sometimes you want to look at the
structure (the columns and column attributes) of a table that you
created or of a table that was created by someone else. 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, that message does not contain information about
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 does not generate output for an empty table.
To display a list of columns ...