One question about STORED COMPILED MACRO

Lee_wan — Wed, 27 Nov 2019 06:39:47 GMT

Hi all,

Recently, I encountered a problem about macro storage.

When I generate a catalog with the following program:

libname MyMacros "&ProjDir.\&Deliver.\Data\SDTM\MetaData";
options mstored sasmstore=MyMacros;
data _null_;
    set MacroList;
    call execute('%include "'||strip(MacroList)||'";');
run; 

proc catalog cat=MyMacros.sasmacr;
    contents;
run;
quit;

Then the sasmacr.sas7bcat was created at target path.

However, whenever I want to update the catalog, if anyone opens sas and reads this catalog, it always reminds me that the file is locked and cannot be updated, which annoy me a lot. I won't be able to update until everyone turns sas off.

So have anyone ever encountered this problem? How to update catalog when locked.

Thanks~

Re: One question about STORED COMPILED MACRO

Kurt_Bremser — Wed, 27 Nov 2019 07:13:52 GMT

You need to use a time window where no SAS session is running that has the sasmstore option set to this catalog. That's the disadvantage of using compiled macros. If you use the autocall library, you do not have that problem.

topic One question about STORED COMPILED MACRO in SAS Programming

One question about STORED COMPILED MACRO

Re: One question about STORED COMPILED MACRO