@samanvi
If you pipe the data through SAS 9.4 as intermediary then look into SAS Access for .... options like readbuff, insertbuff, dbcommit etc. Changing the default values can significantly increase performance.
If these are full unloads/loads then also investigate the options related to bulk unload and load.
All the options are documented under the SAS/Access engine you are using.
Also: If you are creating intermediary SAS tables then also check in what length character variables get created. In the case you know that your DB only stores single byte characters but the encoding is set to something like UTF-8 then on the SAS side each character will get stored with 4 bytes. This not only will impact on performance but it can also lead to string truncation if you've got very long character variables in source. There are also options to influence this behaviour. At a minimum set option compress=yes to ensure that the intermediary SAS table gets stored compressed.
In case you're using SAS Viya there might be additional options to speed up the process if you explain a bit more in detail how your architecture looks like.
... View more