topic Setting default logdir for bulkoad option forrelational database in New SAS User

Setting default logdir for bulkoad option forrelational database

OGA — Thu, 19 Sep 2019 08:11:36 GMT

When user use the bulkload or bulkunload option, they do not set the logdir option which results in nzlogs being saved in the server C:\. I need to set a default directory for these nzlog files so that even though users do not specify a location, it is saved in their work directory H:\temp.

For example, if they specified the logdir, the code would be similar to this:

proc sql;
create table net_air.flights98
       (bulkload=YES bl_options="logdir 'H:\'")
        as select * from sasflt.flt98;
quit;

So I need a way of setting the logdir by default in a config file I guess

More details abour the bulkload and bulkunload options below:

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

Thanks in advance

Re: Setting default logdir for bulkoad option forrelational database

JosvanderVelden — Thu, 19 Sep 2019 09:43:07 GMT

BL_OPTIONS as used here is a data set option. As far as I know it is not possible to set such an option in the sas configuration file.

Re: Setting default logdir for bulkoad option forrelational database

OGA — Thu, 19 Sep 2019 09:53:01 GMT

Thanks for your reply.

Is there any other way to achive what I intend? ie, prevent users from creating logs in the C:\ directory

Thanks

Re: Setting default logdir for bulkoad option forrelational database

ChrisNZ — Mon, 04 May 2020 22:12:26 GMT

Writing to C:\ is not a good default setting.

Asking for a global way to alter this sounds like a good idea. Make a proposal in the SASware ballot.

On the other hand, C:\ is often kept off-limit to users by the OS settings. You could check that.

Failing this, a regular deletion of the files can probably be scheduled.