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!
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.
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...
The NOREPLACE option can be set in several places:
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=(*******)
And if you're not an administrator you can use the OPTIONS statement to set this as well.
option noreplace;
Use the below code to see where SAS is reading the value from:
proc options option=replace value; run;
proc options option=config value;run;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.