Hello All,
I have a question regarding identifying temporary files in EG 5.1. I am trying to import files from MS access by referencing macros. (E.g Filein=&accessfilepath, tablein=A, tableout=A1, etc.) and am receiving an error message
"CLI cursor fetch error: [Microsoft][ODBC Microsoft Access Driver] The query cannot be completed. Either the size of the
query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the
disk to store the query result."
I noticed one way to reduce my temporary file storage is by deleting temp files in "Work" folder under "View"- "SAS Folders"- "Servers" - "Local" - "Library" - "Work". However, almost all my tables in the process flows are stored as "work.XXX" and need to be used. I'm wondering what are the other ways to increase temp folder limit size? or should I change all my "work.XXX" to some other format? Please let me know. Thank you.
I appears you are using a local SAS server, that is SAS on your PC with EG. That means your WORK library is most likely on your PC hard drive (confirm by checking Properties on WORK). Check how much free space you have on your hard drive. If there is a lot then that is probably not causing the error. If you don't have much free space then try deleting files you no longer need and any temporary files.
I appears you are using a local SAS server, that is SAS on your PC with EG. That means your WORK library is most likely on your PC hard drive (confirm by checking Properties on WORK). Check how much free space you have on your hard drive. If there is a lot then that is probably not causing the error. If you don't have much free space then try deleting files you no longer need and any temporary files.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: