Passing Joins to the DBMS Prior to Version 7 of the SAS System, an SQL query involving one or more DBMS tables or view descriptors was processed by the SQL procedure as if the DBMS tables were ...

The PROC SQL statements can be saved and the SAS program can be run in batch whenever you need to update the mirror image tables. SAS tables (data sets) created by automatic joins can also be created ...