SAS maintains indexes for all changes to the table, whether the changes originate from PROC SQL or from some other source ... a unique index cannot be defined for a column that includes NULL or ...

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 ...