Here’s an example of when you should use SQL views. Advertisement. ... Generally speaking, the database management system (DBMS) you use is responsible for keeping views up to date.

You can use Pass-Through Facility statements in a PROC SQL query or store them in a PROC SQL view. The Pass-Through Facility consists of three statements and one component: The CONNECT statement ...

PROC SQL Pass-Through Views A Version 6 PROC SQL Pass-Through view does not need to be updated to be used in Version 7 or Version 8. The conversion of PROC SQL Pass-Through views is automatic and does ...