BookmarkSubscribeRSS Feed
Aexor
Lapis Lazuli | Level 10

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!!!!!!

2 REPLIES 2
LinusH
Tourmaline | Level 20

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.

Data never sleeps
SASKiwi
PROC Star

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.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 386 views
  • 1 like
  • 3 in conversation