topic Re: Write Access Denied in SAS Programming

Write Access Denied

hmadams — Wed, 23 Dec 2020 03:16:07 GMT

I acquired a piece of code and I am getting an error I have not been able to solve

It has a libname statement like this.

  libname  test       'C:\test';

I have checked that the directory C:\test exists and I have RW access

When I try to write to this library for example

data test.new;
	a=1;
run;

I get the error

ERROR: Write access to member TEST.NEW.DATA is denied.

Any help would be appreciated

Re: Write Access Denied

Reeza — Wed, 23 Dec 2020 03:33:42 GMT

Post the error messages you get from the log.

If you're using EG or SAS UE it cannot see your C drive and you need to use a mapped drive in UE. In EG you would need to talk to your administrator.

Re: Write Access Denied

hmadams — Wed, 23 Dec 2020 03:41:50 GMT

Thank you for the response

The problem is specific to this folder. I can change the libname path to other folders on this drive and it will work.

I can navigate to the folder with windows explorer and create a new subfolder, so I thought it was an issue on the SAS side not with my network permissions.

The error is
ERROR: Write access to member TEST.NEW.DATA is denied.

Re: Write Access Denied

SASKiwi — Wed, 23 Dec 2020 03:58:20 GMT

SAS obeys OS permissions. Where is your SAS running? Locally on your PC or remotely on a server.

Re: Write Access Denied

hmadams — Wed, 23 Dec 2020 03:59:31 GMT

Locally on PC

Re: Write Access Denied

hmadams — Wed, 23 Dec 2020 04:03:39 GMT

It does seem there is some R/W issue at work here. I thought testing that I could create a subfolder was enough. I am going to mark this solved. Thank you

Re: Write Access Denied

Reeza — Wed, 23 Dec 2020 04:18:49 GMT

That may be an explicit lockdown. You often do that to ensure people are not writing to the C drive. Otherwise any data on there could in theory be saved onto the hard drive and then it's a security issue that needs to be monitored. A network drive can be wiped remotely and is backed up in comparison.