topic probleme with proc delete in SAS Programming

probleme with proc delete

Nasser_DRMCP — Wed, 06 Jan 2021 10:04:11 GMT

Hello,

I have a program that creates a table Inside the SBOX libray via macro prog and tables in the work Library.

At the end of the program I would like to delete all tables in the work so I do

proc delete library=work ; run ;

My prob is that tables are still existing in the work Library and the sbox table is deleted

many thanks in advance for your help

regards

Nasser

Mr_Kempe — Wed, 06 Jan 2021 10:54:03 GMT

Hi,

You can use PROC DATASETS in combination with the KILL keyword to delete all datasets in a library.

proc datasets library=work kill;
quit;

Be careful, because this statement deletes all tables from the specified library without a warning.

Regards,

Pim

Ksharp — Wed, 06 Jan 2021 11:33:18 GMT

proc delete data=_all_ ; run ;