thank you again macro is working fine for deleting specified files but is there a way we can let this macro to delete files like file1.csv , file1.pdf , file1.xlsx and more formats which we are not aware of ? we just have the file name as file1 but not sure about the extension . I tried putting some linux options but didn't work ... View more

Thank you so much for this. may I know what this 'mq' represents here ... View more

@AllanBowe I don't want to delete the whole directory but few selected files from the directory .   ... View more

what if the files are like test.csv or test.xlsx . can we not handle them using index? my intension is to delete few files from the folder really doesn't matter if I am providing the list of files in a macro or dataset. Also no where I can see this kind a macro   ... View more

data test; infile datalines; input file_nm $50.; datalines; temp1.sas7bndx temp2.sas7bndx temp3.sas7bndx temp4.sas7bndx temp5.sas7bndx temp6.sas7bndx ; run; data _null_; set test; call execute ('%nrstr (%%)macro check; %if %sysfunc(fileexist(file_nm)) ge 1 %then %do; %let rc=%sysfunc(filename(temp,file_nm)); %let rc=%sysfunc(fdelete(&temp)); %end; %else %put The file &file does not exist; %nrstr(%%)mend;'); run; %check ... View more

%macro check(del_file); %if %sysfunc(fileexist(&del_file)) ge 1 %then %do; %let rc=%sysfunc(filename(temp,&del_file)); %let rc=%sysfunc(fdelete(&temp)); %end; %else %put The file &file does not exist; %mend check; %check(/user/rca/temp1.sas7bndx); so I am looking for  a code which can delete multiple files . I have a macro del_file which has list of files  %let del_file = temp1.sas7bndx,temp2.sas7bndx,temp3.sas7bndx,temp4.sas7bndx which I want to delete from /user/rca/. Also this location has more files but I just want to delete selected ones.  ... View more

Thank you so much it worked ... View more