SAS Views

Benefits of Using SAS Views

SAS views provide the following benefits:

Instead of using multiple DATA steps to merge SAS data sets by common variables, you can construct a SAS view that performs a multi-table join.
You can save disk space by storing a SAS view definition, which stores only the instructions for where to find the data and how it is formatted, not the actual data.
SAS views can ensure that the input data sets are always current because data is derived from SAS views at execution time.
Since SAS views can select data from many sources, once a SAS view is created, it can provide prepackaged information to the information community without the need for additional programming.
SAS views can reduce the impact of data design changes on users. For example, you can change a query that is stored in a SAS view without changing the characteristics of the view's result.
With SAS/CONNECT software, a SAS view can join SAS data sets that reside on different host computers, presenting you with an integrated view of distributed company data.

The following figure shows native and interface SAS views and their relationship to SAS data files:

[Native and Interface SAS Data Views]

You can use SAS views in the following ways:

as input to other DATA steps or PROC steps
to migrate data to SAS data files or to database management systems that are supported by SAS
in combination with other data sources using PROC SQL
as pre-assembled sets of data for users of SAS/ASSIST software, enabling them to perform data management, analysis, and reporting tasks regardless of how the data is stored