Hands-On SAS for Data Analysis

Describing views

Before we move on and explore the output of the view, let's find out about the role of the Describe statement. If an analyst has been passed on the name of the view and doesn't have access to the code that was used to create it, they can still see how the view has been constructed. They can see the structure of the view by using the Describe statement. The same statement can be used for a table as well:

Proc SQL;  Describe Table Dealership;  Describe View Sales_MI;Quit;

The following message is written in the LOG:

73 Proc SQL;74 Describe Table Dealership;NOTE: SQL table WORK.DEALERSHIP was created like:  create table WORK.DEALERSHIP( bufsize=65536 )   (    Date num format=DATE9.,    Day char(8),    Car char(8),    Units num, Team char(8), ...