How many rows are there in each table? Is the company database an external RDBMS? If you are joining between a SAS table and an RDBMS then either SAS has to read all of the RDBMS down to SAS and join there, or load the SAS table into the RDBMS and join there. Typically you should load the smaller table into the larger table's environment for best performance.
... View more
