BookmarkSubscribeRSS Feed
Aexor
Pyrite | Level 9

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
Opal | Level 21

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 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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