topic Re: SASGSUB: changing SAS WORK data library location in Administration and Deployment

SASGSUB: changing SAS WORK data library location

IU — Thu, 06 Oct 2016 16:46:48 GMT

I am using SASGSUB in MS Windows batch files to submit SAS code to the SAS Grid.

The batch script code for SAS 9.2 is shown below. The customized config file, sasgsub92.cfg, is located in C:\Users\%username%\SASGrid.

The default SAS WORK data library location assigned to a SAS session created by this submit is WORK= C:\Users\%username%\<_TD…..>

What option should be used to change the default SAS WORK data library location (C:\Users\%username%) to another path?

SET RunSAS="C:\Program Files\SAS\SASFoundation\9.2\sasgsub.exe" -gridconfig "C:\Users\%username%\SASGrid\sasgsub92.cfg" -metauser %username%
%RunSAS% -gridsubmitpgm "%mypath%%pgm%" -gridsasopts " -log '%mylog%.log' -print '%mylst%.lst'"

Thanks,

Re: SASGSUB: changing SAS WORK data library location

owagner — Thu, 06 Oct 2016 16:54:23 GMT

You can use a libname statement like
libname work "<pathname>";

But don't forget: then the work library is permanent!

Regstes, Olaf

Re: SASGSUB: changing SAS WORK data library location

LinusH — Thu, 06 Oct 2016 17:47:58 GMT

-work

Re: SASGSUB: changing SAS WORK data library location

Ksharp — Fri, 07 Oct 2016 03:25:04 GMT

Add option at the top of your code.

options user='c:\temp\';

Re: SASGSUB: changing SAS WORK data library location

IU — Fri, 07 Oct 2016 14:33:17 GMT

Yes, LinusH:

"-work" is the option I am trying to use.

But it does not work in the sasgsub config file (sasgsub92.cfg in my example):

-GRIDSASOPTS "-work \\servername\...."

It works in the sasgsub.exe command line:

-gridsasopts " -work \\servername\...<other SAS options>."

Is there any way to tell the sasgsub.exe command to use the "-work" option from the sasgsub config file?

Thanks,

-IU