CODEWITHSUNDEEP
sas
Khalid
Khalid

Reputation: 661

Change temporary file directory in SAS

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?

Upvotes: 4

Views: 9781

Answers (3)

patrickmdnet
patrickmdnet

Reputation: 3392

You want to change the WORK system option. You can do:

c:\sas\sas.exe -work d:\temp

to use the d:\temp directory.

You can also use the OPTIONS statement within the config file used when starting SAS (thanks Tom):

options work='d:\temp'

See also:

Upvotes: 5

zatka
zatka

Reputation: 63

If you want to permanently change sas work location, you can set it in sasv9.cfg. (Default location: C:\Program Files\SASHome\SASFoundation\9.4\nls\en\sasv9.cfg). Along with -WORK, you may also want to change the value for -UTILLOC option.

You can even spread a Load across Multiple Volumes of Different Disks. Please read Example 1 mentioned in this link - https://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#n1qr5dmzagn9krn1lt1c276963za.htm

Upvotes: 0

Reeza
Reeza

Reputation: 21274

Create a 'user' library instead. When a USER library is in effect, all one level datasets are written to this directory and it's used as the default instead of WORK library. 

 libname user 'path to other location';

Upvotes: 0

Related Questions