8.6. Nesting Views
An important feature of views is that they can be based on other views. This is called nesting. One view can access data that comes through another view. In fact there isn’t a limit to the number of view layers that can be defined. Because of this, views can be a very convenient and flexible way for programmers to retrieve information. Although the number of views that can be nested is virtually unlimited, programmers should use care to avoid nesting views too deeply. Performance- and maintenance-related issues can result, especially if the views are built many layers deep.
To see how views can be based on other views, two views will be created — one referencing the PRODUCTS table and the other referencing the INVOICE table. ...
Get PROC SQL: Beyond the Basics Using SAS® 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.
