looking for suggestion about proc sql connect to DB optimized query

[Aexor]

Hi ,

I have a query. Currently I am facing  ERROR: Insufficient space in file and time issue. I am working on optimization of a SAS code. FOr the same matter I need one suggestion 

In the existing code I can see multiple external db connection  to create some tables in database as 

for e.g  

step 1 .  proc sql noprint;

      connect to db (<credential>);

           execute (

                      create table abc

                   ) by db.;

        disconnect from db;

      ;

   quit;

step 2 . 

proc sql noprint;

      connect to db (<credential>);

           execute (

                      create table xyz

                   ) by db.;

        disconnect from db;

      ;

   quit;

like that I have multiple steps, I can make only one connection and create both xyz and abc table.

will this help in any sort of optimization. any explanation will be very helpful. Thanks!!!!!!

[LinusH]

A full log would be helpful.

And I'm not sure what you mean by optimizing the queries (especially when you don't show them).

The no of connect/execute shoudldn't matter.

Also, if all your queries are within EXECUTE blocks, the performance issue is most likely in the external DB, not in SAS. So perhaps try to get help from your DBA or any other knowledable in your database.

[SASKiwi]

Please post a complete log of your program including notes and errors. Posting errors like "ERROR: Insufficient space in file and time issue" without seeing the code that caused them means we can't provide useful advice.