We use SAS 9.4 on a Linux platform. All Studies share the same MS SQL DB Tables and I only want to overwrite the data for the Study currently being processed. So, I wrote a macro that: Creates a temporary DB table from the current Study’s SAS dataset. Deletes the current Study’s data from the permanent DB table. Loads the temporary DB table into the permanent DB table. Drops the temporary DB table. Everything works beautifully. However, since we cannot create a MS SQL Server table from a SAS dataset using explicit pass through SQL, I have to create the temporary DB table using implicit pass through. PROBLEM: Creating the temporary DB table using implicit pass through takes over 2 hours to load 5 million records. Is there a better way of doing this? Below is my macro. Any help much appreciated 🙂 ... View more