topic Re: Using SAS code to delete .csv files in a folder in SAS Procedures

Using SAS code to delete .csv files in a folder

Jack1 — Thu, 02 Jun 2016 16:38:35 GMT

I have SAS code that takes multiple Excel tabs and exports each of them into the same directory as .csv files. Using PROC IMPORT each of these csv files are used to create individual SAS datasets via SAS EG.

My question: Once my SAS datasets are created I have no need for these csv files. How would I code my program to delete these csv files?

Thanks.

Jack

Re: Using SAS code to delete .csv files in a folder

Haikuo — Thu, 02 Jun 2016 17:05:08 GMT

FDELETE

Re: Using SAS code to delete .csv files in a folder

Reeza — Thu, 02 Jun 2016 17:49:11 GMT

So I understand correct, the Excel file is converted to CSV, then imported to SAS. Now you want to delete the CSV files?

I'm assuming you're using x commands at some point so you could use

X 'RM path_to_file.csv;

Re: Using SAS code to delete .csv files in a folder

Jack1 — Thu, 02 Jun 2016 18:17:33 GMT

To answer your original question:

So I understand correct, the Excel file is converted to CSV, then imported to SAS. Now you want to delete the CSV files?

Yes, that is correct.

But I have 12 csv files to delete (in a future run, I will a lot more). How can I efficeintly code this? I have 12 csv files that are named by month of the year (Jan, Feb, etc.).

Thanks

Re: Using SAS code to delete .csv files in a folder

Reeza — Thu, 02 Jun 2016 18:25:15 GMT

Assuming you're on Windows you can use a wildcard in your command.

Find the appropriate system command to remove all files that end with .CSV

X "rm folder/*.csv"

Re: Using SAS code to delete .csv files in a folder

Jack1 — Thu, 02 Jun 2016 18:29:36 GMT

Great, thanks for quick reply...