SAS maintains indexes for all changes to the table, whether the changes originate from PROC SQL or from some other source ... You can use the CONTENTS statement in the DATASETS procedure to display a ...
intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database table and index structures. Maintain ...
If indexes are defined on columns in the table ... you may want to use the FEEDBACK option in the PROC SQL statement. This option displays in the SAS log how the underlying view is defined and expands ...