Hi Everyone, I have recently encountered a significant decrease in performance when running codes in SAS Enterprise Guide. This issue started after renewing our SAS license. I am using a SAS server with an Oracle connection.   While monitoring the SAS local temp folder, I noticed that .SAS7butl files are being generated specifically during the process of joining tables. These files are taking a considerable amount of time and space. After their completion, another file with the .SAS7bdat.lck extension is created, followed by the final creation of the dataset (physical table) on the local server. Additionally, the size of the two tables remains unchanged until the physical table is finalized.   Is this a standard practice? I am familiar with .SAS7bdat.lck files, but I have never come across .SAS7butl files before. Prior to this issue, the same query (proc SQL) would take 5 minutes to run, but now it is taking around 30 minutes.   Could someone please explain how SAS manages this process, and do you have any recommendations for resolving this issue? It's worth noting that there have been no changes made to the Oracle database or the server. Thank you. ... View more