Hello everyone, At my current position there are a variety of Oracle tables that I have to use. For the most part I am using reading these tables in and performing analysis based on them, but on occasion I need to make some edits or create new variables in the tables. Unfortunately the performance for any writing/modifications or creation of new Oracle tables using PROC SQL seems to be very slow. I have tried making some of the modifications suggested in this article: https://www.lexjansen.com/nesug/nesug05/io/io8.pdf such as setting readbuff and insertbuff in the libname statement, but that doesn't seem to have made much of a difference. Does anyone know any other settings I could change to try to improve the performance of PROC SQL, or alternatively if I could get better performance with a Data step or another technique? Thank you! ... View more