probleme with proc delete

[Nasser_DRMCP]

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 · Accepted solution]

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]

proc delete data=_all_ ; run ;