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:
-
-
-
-
-
DB2, ORACLE, or other DBMS data