topic Re: Access=readonly in SAS Programming

Access=readonly

Sarah-R — Wed, 19 May 2021 15:39:44 GMT

What is the opposite of Access=readonly?

Can a data set that has had been made access readonly be reverted back to read and write? How do I revert it back to access read and write?

Re: Access=readonly

PaigeMiller — Wed, 19 May 2021 15:46:55 GMT

In a LIBNAME statement, just re-run the LIBNAME without access=readonly on the end.

Re: Access=readonly

Kurt_Bremser — Wed, 19 May 2021 15:46:59 GMT

ACCESS=READONLY is not a dataset option, but an option of the LIBNAME statement. Therefore, if you clear the libname and re-assign the library for the same path without the option, it becomes writable.

Re: Access=readonly

sbxkoenk — Wed, 19 May 2021 15:48:43 GMT

Hello,

I guess your dataset is read-only because of the library it is residing in.

Maybe that library was assigned with the 'access=readonly' option??

Clear the libname and assign it again to the same path but without the access=readonly option. This has an effect on all library members of course!

Or the dataset was made read-only in the OS, then you have to switch off read-only on the OS as well.

Cheers,

Koen

Re: Access=readonly

Tom — Wed, 19 May 2021 15:54:36 GMT

Make a new libref. Depending on how the original libref is defined you might be able to do it using the PATHNAME() function.

libname readonly "mydirectory" access=readonly;
libname write "%sysfunc(pathname(readonly))" ;