topic Re: Where is SAS config file that sets SAS system option to NOREPLACE? in SAS Enterprise Guide

Where is SAS config file that sets SAS system option to NOREPLACE?

elena_ziemke_capblurcross_com — Mon, 22 Jan 2018 16:30:38 GMT

I am looking for a configuration SAS file that will have a Replace/Noreplace option setting. Where in the SAS/Config directory is it?

Thank you!

Re: Where is SAS config file that sets SAS system option to NOREPLACE?

SangramjitPanda — Mon, 22 Jan 2018 16:57:46 GMT

By default the option REPLACE is enabled. You can use following files to update with NOREPLACE.

sasv9_local.cfg : ~/SASHOME/SASFoundation/9.4/ (i.e ~/SASRoot)

you can also set this option in autoexec_usermods.sas located at: ~/SASCONFIG/Lev1/SASApp/WorkspaceServer

remember to use the Autoexec option included in sasv9_local.cfg.

Re: Where is SAS config file that sets SAS system option to NOREPLACE?

Reeza — Mon, 22 Jan 2018 16:59:58 GMT

And if you're not an administrator you can use the OPTIONS statement to set this as well.

option noreplace;

Re: Where is SAS config file that sets SAS system option to NOREPLACE?

elena_ziemke_capblurcross_com — Mon, 22 Jan 2018 19:21:54 GMT

In our test environment we get this message when running SAS processes

WARNING: Data set SASDATA.XXX was not replaced because of NOREPLACE option.

In production we don't get this message so I was trying to figure out where this NOREPLACE option is set but I can't find it. I checked sasv9.cfg files in multiple locations but I don't see this option in any of these .cfg files...

Re: Where is SAS config file that sets SAS system option to NOREPLACE?

Reeza — Mon, 22 Jan 2018 19:28:52 GMT

The NOREPLACE option can be set in several places:

SAS 9.4: Configuration file,
SAS invocation,
OPTIONS statement,
SAS System Options window

http://documentation.sas.com/?docsetId=lesysoptsref&docsetTarget=n16q7psnp46obtn1hqbni4o7f6qg.htm&docsetVersion=9.4&locale=en

Re: Where is SAS config file that sets SAS system option to NOREPLACE?

nhvdwalt — Tue, 23 Jan 2018 04:08:36 GMT

Use the below code to see where SAS is reading the value from:

proc options option=replace value;
run;

Re: Where is SAS config file that sets SAS system option to NOREPLACE?

SangramjitPanda — Tue, 23 Jan 2018 09:11:16 GMT

Use the below code to identify the location of config files:

proc options option=config;
run;

In the log, check for the below information:

SAS (r) Proprietary Software Release 9.4 TS1M3

CONFIG=(*******)

Re: Where is SAS config file that sets SAS system option to NOREPLACE?

Ksharp — Tue, 23 Jan 2018 13:04:22 GMT

proc options option=config value;run;