Chapter Contents

Previous

Next

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 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 set(s) or view(s).

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 the SAS Procedures Guide.

Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.