Hi all,
I need to use PROC.SQL statements for my analysis. The problem is, SAS uses C disk in order to create temporary files when I use SQL statements. My datasets are very large and I do not have enough space for that. Could you please explain me how to allocate this temporary file in other place rather than C disk?
Note that the solution you've linked to is a permanent change for where your WORK directory is stored. If that post answered your question, please mark it as the solution.
Use the -utilloc option, either in a config file or on the SAS commandline.
@Khaladdin wrote:
how to use it?
I alreaady told you that. Which config file or shell script (commandline) depends on your SAS setup.
The C drive is used when you're either
1. Accessing a DBMS but using functions that are not supported on the DBMS
2. Using data both in SAS and on the server - the data is then brought down the server to be processed.
3. All your data is local.
Identify which situation you're in first.
If #3, there aren't any workarounds.
If its 1/2 you can modify your query so that it's processed on the server instead.
One workaround is to compress your SAS datasets at the expense of slowing your programs down a bit. Put this at the start of your program. If you are lucky it might give you enough space to complete your job successfully. At the end of the day you may still need to put another hard drive in your PC. Warning - don't write SAS temporary files to a network drive unless you want your programs to run forever and seriously annoy IT administrators.
options compress = binary;
I followed that link and it worked:
Note that the solution you've linked to is a permanent change for where your WORK directory is stored. If that post answered your question, please mark it as the solution.
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 25. Read more here about why you should contribute and what is in it for you!
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.