SAS/ACCESS Software for Relational Databases: Reference

Creating SAS Views

Depending on which SAS/ACCESS feature you use, there are several ways to create a SAS view. A SAS view is a stored query that retrieves rows from a SAS data set or DBMS table. Creating SAS Views lists the easiest way to create a view, depending on which feature you use.

Creating SAS Views
If you use this SAS/ACCESS feature to access DBMS data... you should use this SAS view technology...

SAS/ACCESS LIBNAME statement PROC SQL view or DATA step view of the DBMS table

SQL Procedure Pass-Through Facility PROC SQL view with CONNECTION TO component

ACCESS Procedure SAS/ACCESS view, which is a PROC ACCESS view descriptor

***Creating SAS Views***
If you use this SAS/ACCESS feature to access DBMS data...	you should use this SAS view technology...
SAS/ACCESS LIBNAME statement	PROC SQL view or DATA step view of the DBMS table
SQL Procedure Pass-Through Facility	PROC SQL view with CONNECTION TO component
ACCESS Procedure	SAS/ACCESS view, which is a PROC ACCESS view descriptor

Chapter Contents
Previous
Next
Top of Page