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.
... View more
