topic Re: delete intermediate datasets in SAS Programming

delete intermediate datasets

ravindra2 — Wed, 31 Oct 2018 06:21:10 GMT

hi i am having 3 datasets which are suppurated by td_ i want to delete those datasets using code and these datasets stored in work library.

td_class;

td_cars;

td_heart;

these are my datasets.

data td_class;
set sashelp.class;
run;

data td_cars;
set sashelp.cars;
run;

data td_heart;
set sashelp.heart;
run;

thank you.

PeterClemmensen — Wed, 31 Oct 2018 06:42:44 GMT

Do like this

proc datasets lib=work nolist;
   delete td_class td_cars td_heart;
run;quit;

ravindra2 — Wed, 31 Oct 2018 06:47:54 GMT

yes i agree with you but i need in condition code

i created every dataset as td_ so i want to delete every dataset which is starting with 'td_' or separated by '_' thank you

PeterClemmensen — Wed, 31 Oct 2018 06:52:12 GMT

PROC DATASETS supports the colon operator like this

proc datasets lib=work nolist;
   delete td:;
run;quit;