SAS Certification Prep Guide, 4th Edition

Summary

Text Summary

Using PROC SQL Views

A PROC SQL view is a stored query that is executed when you use the view in a SAS procedure or DATA step. A view contains only the descriptor and other information required to retrieve the data values from other SAS files (SAS data files, DATA step views, or other PROC SQL views) or external files (DBMS data files). When executed, a PROC SQL view's output can be a subset or superset of one or more underlying files. A view contains no data, but describes or defines data that is stored elsewhere.

PROC SQL views

• can be used in SAS programs in place of an actual SAS data file
• can be joined with tables or other views
• can be derived from one or more tables, PROC SQL views, DATA step views, or ...