Hi,
I've been trying to import some data as csv file, however I am getting an error:
5 The SAS System 19:26 Thursday, February 2, 2017
43 Options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND;
44 %macro deletedsifexists(lib,name);
45 %if %sysfunc(exist(&lib..&name.)) %then %do;
46 proc datasets library=&lib. nolist;
47 delete &name.;
48 quit;
49 %end;
50 %mend deletedsifexists;
51
ERROR: Metadata Server denied access to operation.
52 /* Remove target data table from Library */
53 %deletedsifexists(LASRLIB, salesrbt);
54
55
I have tried removing spaces from the output table name as one of the sugesstions from google. I am still not able to get through. Kindly help!!!!
Thanks,
Jitin Sethi
I am using SAS VA and it auto creates the delete macro that you are seeing in the error log.
I got my issue fixed after deleting the AUTOLOAD Log fines from the server. There were around 30,000 log files that were required to be cleared.
Thanks!
What type of SAS are you using, e.g. Enterprise Guide, DI, etc. This post should most definately not be in Community Matters!
Include the libname statement and matadata server options if you have any.
My guess is that you either has a META engine allocation that doesn't allow delete operations, or perhaps you are working with a metadata bound library?
If you are trying to import CSV then why are you attempting to delete a data set? If successful the import will overwrite the existing data set.
I suspect that you have issues about permissions with that library
run this code:
Libname LASRLIB list;
Look at the log to see characteristics and see if you have something like READONLY
I am using SAS VA and it auto creates the delete macro that you are seeing in the error log.
I got my issue fixed after deleting the AUTOLOAD Log fines from the server. There were around 30,000 log files that were required to be cleared.
Thanks!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.