topic Re: How to remove specfic macros stored as catalogs in sas macro catalog in SAS Programming

How to remove specfic macros stored as catalogs in sas macro catalog

sri1 — Thu, 24 Oct 2024 15:58:53 GMT

I have a sas macro catalog named test. This catalog contains list of macros (stored as catalogs). I want to remove specific catalogs from test. Is there a way to do in SAS?

For example test contains A,B,C ,V_A,V_B,V_C.I want to keep only A,B,C.

Appreciate your response.

Re: How to remove specfic macros stored as catalogs in sas macro catalog

ChrisHemedinger — Thu, 24 Oct 2024 16:20:28 GMT

You can accomplish this with PROC CATALOG. Do you have SAS Enterprise Guide? The Catalog and Formats Explorer (in the Tools menu) can help generate this code for you.

Re: How to remove specfic macros stored as catalogs in sas macro catalog

Tom — Fri, 25 Oct 2024 03:04:49 GMT

@sri1 wrote:

I have a sas macro catalog named test. This catalog contains list of macros (stored as catalogs). I want to remove specific catalogs from test. Is there a way to do in SAS?

For example test contains A,B,C ,V_A,V_B,V_C.I want to keep only A,B,C.

Appreciate your response.

Your terminology is messed up. The catalog cannot contain other catalogs. A "macro catalog" usually means a SAS catalog file that contains compiled macros. The object (or entry) type for a compiled macro is 'MACRO'. The object name is the macro's name.

You can use PROC CATALOG to manage catalog entries. Use the SAVE command if you want to delete all but the listed entries. So if your catalog name is MYLIB.MYMACROS then the code would look like:

proc catalog cat=MYLIB.MYMACROS entrytype=macro;
  save a b c ;
run;

Re: How to remove specfic macros stored as catalogs in sas macro catalog

sri1 — Fri, 25 Oct 2024 08:49:59 GMT

Thanks for your response,am using sas 9.4

Re: How to remove specfic macros stored as catalogs in sas macro catalog

sri1 — Fri, 25 Oct 2024 09:40:25 GMT

Thanks for your response. There are numerous macros with prefix V_ , is there a way I can delete all the macros with prefix V_

Re: How to remove specfic macros stored as catalogs in sas macro catalog

ChrisHemedinger — Fri, 25 Oct 2024 12:15:19 GMT

You can build the list of macros to delete using PROC SQL and the SASHELP.VCATALG list, then use that list in PROC CATALOG.

Let's assume your macros are in a catalog named MYMACROS within the library MYLIB, and you want to catch the "V_*" named macros:

proc sql noprint; select objname into: vmacs separated by ' ' from sashelp.vcatalg where substr(objname,1,2) = "V_" and libname='MYLIB' and memname='MYMACROS' and objtype='MACRO'; quit; /* space-delimited list of matching macro names */ %put &=vmacs; proc catalog cat=MYLIB.MYMACROS entrytype=macro; delete &vmacs.; run; quit;

Re: How to remove specfic macros stored as catalogs in sas macro catalog

sri1 — Sat, 26 Oct 2024 03:28:59 GMT

Appreciate your response, thanks