Hi I am trying to delete a file by passing the filename in a variable. When using my delete macro the file deletes if I put the name there however when using my variable it doesnt work %include "C:/list.sas"; /*file paths*/ %let path_in= C:/FileCheck; /*List of files*/ %list_files("C:/FileCheck",txt) proc sql; create table filecount as select name as filename from tables (obs = 1); quit; %macro check(file); %if %sysfunc(fileexist(&file)) ge 1 %then %do; %let rc=%sysfunc(filename(temp,&file)); %let rc=%sysfunc(fdelete(&temp)); %end; %else %put The file &file does not exist; %mend check; data tsave; length y fname $200; do i = 1 to 3; y = cats("C:/","&filename"); fname = y; output; file dummy filevar=y; %check('&y') end; run; ... View more

hi, I have a macro that outputs the list of files in a directory.  Thereafter I do a count so that  I can save this number of files in a variable. My issue comes in when there are zero files in the directory, how do I handle this as this zero is not saved in the variable  %list_files("C:/Files",txt) /*The above macros shows the results in a dataset called tables*/ /*Count number of files*/ proc sql; create table filecount as select count(name) into: filecount from tables; quit; %if &filecount. = 0 %then %goto section1; /*This is where it breaks as the 0 is not stored in the &filecount variable*/ ... View more

hi    I check a directory to see if there are files. If there are no files I create a csv file in it however when creating the file it populates the results of checking the directory. Is there a way to create an empty file or empty the contents of my csv file? data _null_ ; filename pathdir "%C:/FileCheck"; did = dopen("pathdir"); numfiles =dnum(did); rc = dclose(did); run; %if(&did = 0) %then %do; proc export outfile="C:/Log.csv" dbms=tab; run; %end; ... View more