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
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!!!!!!
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.
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 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.