topic Re: FCOPY in scheduler copies file as read only, but read/write when run manually in SAS Data Management

FCOPY in scheduler copies file as read only, but read/write when run manually

AviS — Fri, 08 May 2020 15:45:31 GMT

Hello!!

I have a SAS program which when I run manually copies file with read/write access but when run in scheduler in SAS Server copies file only with read access.

How can I resolve it to copy files with read/write access even when run in SAS server scheduler?

data _null_;

rc=fcopy('src', 'dest');

run;

Re: FCOPY in scheduler copies file as read only, but read/write when run manually

Tom — Fri, 08 May 2020 18:48:15 GMT

Can you run system commands from SAS? Is SAS running on some flavor of Unix?

Perhaps SAS is using the umask setting of the process that started SAS?

Check your umask setting.

Personally I like to use 002 as the umask instead of 022 so that new files are created with both user and group write bits set to enable teamwork.

If you can run system commands and are using unix then use the cp command with -p option to preserve the permission when copying the file.

Re: FCOPY in scheduler copies file as read only, but read/write when run manually

Kurt_Bremser — Fri, 08 May 2020 18:31:03 GMT

The scheduler runs from another userID than your "manual" execution. If it uses the standard umask of 022, only the scheduler user will have write permission.