topic Re: Deleting multiple SAS data files in SAS Programming

Deleting multiple SAS data files

BayzidurRahman — Mon, 08 May 2023 01:31:39 GMT

Is there any ways to delete multiple data files based on their index number? For example, a process is generating 20 datasets named as Data1, Data2 ... Data20. I need to keep only data20. Is there any easy way to do that without mentioning all the file names? This process shouldn't interfere with data files named with different prefix (e,g., SASdata1, SASdata2 etc).

Re: Deleting multiple SAS data files

Tom — Mon, 08 May 2023 02:08:25 GMT

Use PROC DATASETS. It supports dataset lists.

Try this numeric suffix range:

data data1 data2 data3 data4;
run;

proc datasets nolist lib=work;
  delete data1-data4;
run;
quit;

Any suffix:

data data1 data2 data3 data4 data10;
run;

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

Re: Deleting multiple SAS data files

BayzidurRahman — Mon, 08 May 2023 02:15:10 GMT

Thanks Tom. That works.

Re: Deleting multiple SAS data files

SASKiwi — Mon, 08 May 2023 02:16:24 GMT

An alternative approach could be to write ALL of your sequenced datasets to your WORK SAS library, then only copy DATA20 to a permanent SAS library. When your SAS session ends only DATA20 is kept. As a general rule writing only datasets you want to keep to permanent SAS libraries means you don't need to tidy up at the end of your SAS sessions.