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
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
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.