PROC SQL Views

A PROC SQL view is a PROC SQL query expression that is given a name and stored for later use. When you use a PROC SQL view in a SAS program, the view derives its data from the data sets (often referred to as tables) or SAS views listed in its FROM clause. The data that is accessed by the view is a subset or superset of the data in its underlying data sets or SAS views.
A PROC SQL view can read or write data from:
  • DATA step views
  • SAS data files
  • other PROC SQL views
  • SAS/ACCESS views
  • DB2, ORACLE, or other DBMS data
For complete documentation on how to create and use PROC SQL views, see Base SAS Procedures Guide.
For information about using PROC SQL views created in an earlier release, see SAS 9.3 Compatibility with SAS Files from Earlier Releases.