Load the SAS dataset into Oracle - eventually into a temporary table - to execute the join in-database.
This of course is only worth doing if the inner join will significantly reduce the volume meaning that the resulting table you will load into SAS is much smaller than the source table in Oracle.
Hello @nickspencer
Optimizing query performance depends on the details of your query and I have a general observation.
You are having a heterogeneous join. if your SAS dataset is the smaller one I would suggest try moving to a temporary table into Oracle and then perform the join and fetch the result.
Do not forget to delete the temporary table in oracle.
Again the devil is in the detail.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.