Create SQL Query Views

You can influence whether the work table or output table is a view or a table. To specify view, select the Create an SQL query view check box on the Properties tab. The option is enabled by default. In most cases, this option improves performance by reducing data movement and storage requirements.

When working with tables in a database, if the source tables and output tables are in the same library, the Create an SQL query view option can enable you to pass a CREATE VIEW statement directly to the database. When this happens, the data query runs almost instantaneously because there is no data movement to create a view.

The following table summarizes the interactions between library types and views:

Library Type	Interactions
Base SAS	Base SAS libraries always support views for output tables or staging tables. Source tables can be from different libraries because the connection information is stored in the view.
DBMS	If the source tables and the output tables or staging tables are in the same library, then the view is created in the database. If they are in different libraries, then the check box is not enabled and the output table or staging table is created as a physical table.
SAS LASR Analytic Server or SASHDAT	These libraries types do not support views. Selecting the check box applies to the work table, rather than the output table or staging table. If the source tables and the output tables are in the same SAS LASR Analytic Server library, then the check box is not enabled, and the work table must be a physical table.

Note: In some cases, the check box is enabled, but using this option can result in an error when running the data query. For example, if you use a DBMS library for the output table, you must have permission to create a view. You can clear the check box to create the output table as a physical table in these cases.

Last updated: January 8, 2019