topic Re: Deleting a catalog entry - alternative to proc catalog in SAS Procedures

Deleting a catalog entry - alternative to proc catalog

xxformat_com — Wed, 15 Feb 2023 18:39:22 GMT

Right now, I'm only aware of the procedure proc catalog to delete a catalog entry.

However, the online documentation indicates that proc catalog is not supported by CAS.

So I was wondering what alternatives are available to delete catalog entries.

Here is a demo program to give something to test against.

filename demo catalog 'work.pgm.procprint.source';
*filename demo temp;

data _null_; 
	file demo; 
	put 'proc print data=sashelp.class;'; 
	put 'run;'; 
run;

%include demo; 
filename demo;

proc catalog catalog=work.pgm;
    delete procprint / entrytype=source;
    run;
quit;

Re: Deleting a catalog entry - alternative to proc catalog

ChrisHemedinger — Wed, 15 Feb 2023 19:04:52 GMT

You can still use PROC CATALOG in SAS Viya -- it will just run in the Compute server, not in CAS. Or are you working from an environment where you have only a CAS connection and no Compute server available?

Re: Deleting a catalog entry - alternative to proc catalog

SASKiwi — Wed, 15 Feb 2023 20:22:20 GMT

I can't think of any good reason why you would want to load a SAS catalog into a CAS library. In fact it looks like V9-style SAS catalogs are not supported in CAS libraries anyway. There is a special use case for SAS formats that a stored in V9-style SAS catalogs in SAS 9 and these can be migrated to a Viya CAS library but are stored in a different form. Here is the doc link for that.