Creating and Using PROC SQL Views
PROC SQL Views
A PROC SQL view is a stored query that is executed when
you use the view in a SAS procedure or DATA step. A view contains
only the descriptor and other information required to retrieve the
data values from other SAS files (SAS data files, DATA step views,
or other PROC SQL views) or external files (DBMS data files). The
view contains only the logic for accessing the data, not the data
itself.
Because PROC SQL views are not separate copies of data, they are referred to as virtual tables. They do not exist as independent entities like real tables. However, views use the same naming conventions as tables and can be used in SAS programs in place of an actual SAS table. Like tables, views are considered ...
Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
