Summary
Text Summary
Using 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). When executed, a PROC SQL view's output can
be a subset or superset of one or more underlying files. A view contains
no data, but describes or defines data that is stored elsewhere.
PROC SQL views
-
can be used in SAS programs in place of an actual SAS data file
-
can be joined with tables or other views
-
can be derived from one or more tables, PROC SQL views, DATA step views, or ...
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.
