Displaying the Structure of a Table
Overview
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
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 does not generate output for an empty table.
To display a list of columns ...
Get SAS Certification Prep Guide, 4th Edition 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.
