BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ravindra2
Fluorite | Level 6

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

PROC DATASETS supports the colon operator like this

 

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

View solution in original post

3 REPLIES 3
PeterClemmensen
Tourmaline | Level 20

Do like this

 

proc datasets lib=work nolist;
   delete td_class td_cars td_heart;
run;quit;
ravindra2
Fluorite | Level 6

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
Tourmaline | Level 20

PROC DATASETS supports the colon operator like this

 

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 2189 views
  • 2 likes
  • 2 in conversation