topic Re: User does not have appropriate authorization level for file sas in SAS Programming

User does not have appropriate authorization level for file sas

TesterSK — Tue, 18 May 2021 15:36:33 GMT

Hi all,

I get this error when the program is going to create a dataset on a Linux server and has not yet deleted it. This program is made in SAS Data Integration, so I have many programs that drop a table and then create it to replace it.

I have observed that this error appears in certain programs that create a table with small size. Sometimes this error appears, and sometimes it does not. I think SAS drops the table and tries to create it when it hasn't dropped it yet.

Is there any parameter to fix this?

MPRINT(EXECUTION):  ;
MPRINT(EXECUTION):   option DBIDIRECTEXEC;
MPRINT(EXECUTION):   proc datasets lib = TEST nolist nowarn memtype = (data view);
MPRINT(EXECUTION):   delete TEMP_DAT_CONCEP;
MPRINT(EXECUTION):   quit;

NOTE: Deleting TEST.TEMP_DAT_CONCEP (memtype=DATA).
23                                                         The SAS System                                02:07 Tuesday, May 18, 2021

NOTE: PROCEDURE DATASETS ha utilizzato (tempo totale di elaborazione):
      real time           0.10 seconds
      cpu time            0.00 seconds
      

MPRINT(EXECUTION):   proc sql;
MPRINT(EXECUTION):   create table TEST.TEMP_DAT_CONCEP as select .................... from work.example ;
ERROR: User does not have appropriate authorization level for file TEST.TEMP_DAT_CONCEP.DATA.

Re: User does not have appropriate authorization level for file sas

CarmineVerrell — Tue, 18 May 2021 15:42:39 GMT

Fist thing i would want you to check is, what are your permissions on the linux directory that you are trying to write to.

Re: User does not have appropriate authorization level for file sas

TesterSK — Tue, 18 May 2021 15:46:34 GMT

664 are the permissions for all my datasets. I think this is not the problem.

Re: User does not have appropriate authorization level for file sas

CarmineVerrell — Tue, 18 May 2021 15:51:20 GMT

Also, just want to note that you should also check with you SAS admin and see if you have appropriate access on linux location. Its possible that you are dealing with a metadata bound library created by your SAS admin. A Metadata bound library can set permissions on sas data that is not registered in metadata .

Re: User does not have appropriate authorization level for file sas

Kurt_Bremser — Tue, 18 May 2021 15:58:27 GMT

How is library TEST defined?

Is it a Base SAS library, or something else? Is it assigned through a simple LIBNAME statement (by you or in the autoexec file), or is it defined in metadata and pre-assigned?

If Base SAS, where does it reside? Local to the SAS server, or on a network share?

Re: User does not have appropriate authorization level for file sas

TesterSK — Tue, 18 May 2021 16:03:37 GMT

I use a libname statement like the log says:

MPRINT(EXECUTION): LIBNAME TEST BASE "/XXXX/xxxxx/xxxx/XX";
NOTE: Libref TEST was successfully assigned as follows:
Engine: BASE
Physical Name: /XXXX/xxxxx/xxxx/XX
NOTE: The macro RCSET is executing from memory.
21 instructions 456 bytes.

The libname resides in a directory server

Re: User does not have appropriate authorization level for file sas

Kurt_Bremser — Tue, 18 May 2021 16:16:55 GMT

If, by "directory server", you mean a network share, then you may have a timing issue; add a short delay between the remove and the write, e,g,

%let rc=%sysfunc(sleep(5,1));

Re: User does not have appropriate authorization level for file sas

Kurt_Bremser — Tue, 18 May 2021 16:18:26 GMT

Also, in case of a failure, do immediately check if the delete in the DATASETS procedure worked (use Windows Explorer or similar to see if the .sas7bdat file still exists).