topic Re: utilloc option in configuration file in SAS Data Management

utilloc option in configuration file

RealePrimavera — Tue, 02 Jul 2019 15:47:03 GMT

I need to divert utility files to a larger space than work library. (working with proc ginside that seems to create a big threaded utility file and creating error of insufficient space in work library).

One of the solutions I found is to add options utilloc='larger space path' in configuration. However, I am getting this error message while changing my configuration.

Will be helpful to know if someone is familiar with this option. I am using 9.4 version and Enterprise Guide interchangeably; both of which has same config. file as I understand.

Re: utilloc option in configuration file

Reeza — Tue, 02 Jul 2019 16:13:33 GMT

How exactly are you specifying the option in the config file?

Specifically, you don't have the options keyword in the statement?

https://documentation.sas.com/?docsetId=hostunx&docsetTarget=p13flc1vsrqwr8n1vutzds8rp3t0.htm&docsetVersion=9.4&locale=en

It should likely be:

-utilloc 'path to file'

@RealePrimavera wrote:

I need to divert utility files to a larger space than work library. (working with proc ginside that seems to create a big threaded utility file and creating error of insufficient space in work library).

One of the solutions I found is to add options utilloc='larger space path' in configuration. However, I am getting this error message while changing my configuration.

Will be helpful to know if someone is familiar with this option. I am using 9.4 version and Enterprise Guide interchangeably; both of which has same config. file as I understand.

Re: utilloc option in configuration file

RealePrimavera — Tue, 02 Jul 2019 16:51:38 GMT

Thanks, Reeza for pointing out. I was in fact using "options" in the statement; changed it now per the document.

However, my intermediate utility files are not being directed yet to the new path and I am back to the same error of "insufficient space in work library". Any idea about why/how?

Currently, my configuration file reads as:

-config "C:\Program Files\SASHome\SASFoundation\9.4\nls\en\sasv9.cfg"
-utilloc="D:\utility"

Re: utilloc option in configuration file

Reeza — Tue, 02 Jul 2019 17:03:19 GMT

How big is the file you're working with and how big is the space on the D drive. And how much RAM do you have? Post the code and the exact error would likely help as well.

Re: utilloc option in configuration file

ErikLund_Jensen — Tue, 02 Jul 2019 18:36:36 GMT

Hi @RealePrimavera

Did you create the physical folder D:\utility on your D drive? - I think the folder must exist before SAS is started.

Re: utilloc option in configuration file

Tom — Tue, 02 Jul 2019 21:28:44 GMT

Do you want the equal sign? You didn't use one for the -config option.

Re: utilloc option in configuration file

Patrick — Wed, 03 Jul 2019 07:59:48 GMT

@RealePrimavera

You can either define this in a configuration file (..._usermods.cfg) or in an autoexec (..._usermods.sas).

https://go.documentation.sas.com/?docsetId=lesysoptsref&docsetTarget=p1texr4rxo0ipyn1ovajj11raccx.htm&docsetVersion=9.4&locale=en

In a config file the syntax is:

-utilloc "D:\utility"

In an autoexec the syntax is:

options utilloc="D:\utility";

UTILLOC should point to your disk with the best I/O or there will be a negative performance impact.

Re: utilloc option in configuration file

RealePrimavera — Wed, 03 Jul 2019 09:20:57 GMT

Thank you, @Patrick

In fact, I was using equal signs misled by utilloc document which for options statement.

In configuration file, one needs to mention the options with hyphen sign.

Here, is the configuration syntax document for future explorers:

https://go.documentation.sas.com/?docsetId=hostwin&docsetTarget=p0drw76qo0gig2n1kcoliekh605k.htm&docsetVersion=9.4&locale=en#p0273uv4qrgcrjn16vg7muluuhrz

Best,

Re: utilloc option in configuration file

RealePrimavera — Wed, 03 Jul 2019 09:22:04 GMT

good point though I already had it created 🙂