Using SAS to delete a text file

sas sas-macro
Allan Bowe picture Allan Bowe · Nov 15, 2012 · Viewed 9.6k times · Source

Am looking for a piece of code, preferably OS independent and macro based, for deleting a text file (or any file for that matter)

Answer

Joe picture Joe · Nov 15, 2012

From SAS documentation:

data _null_;
    fname="tempfile";
    rc=filename(fname,"physical-filename");
    if rc = 0 and fexist(fname) then
       rc=fdelete(fname);
    rc=filename(fname);
run;

It's essentially OS independent, in that it will work on multiple OS's. You can't ever have true independence since the fileref would be OS-dependent, but if you specify that as an argument it shouldn't be a problem.

As a macro, you would use FDELETE in a SYSFUNC block:

%put %sysfunc(fdelete(myfile));

However, myfile needs to be a fileref, so if you were using only the file's actual physical location as an argument you'd need two steps:

%macro file_Delete(file);
filename __a "&file.";
%put %sysfunc(fdelete(__a));
%mend file_delete;

Related questions

Using SAS Macro to pipe a list of filenames from a Windows directory

I am trying to amend the macro below to accept a macro parameter as the 'location' argument for a dir command. However I cannot get it to resolve correctly due to the nested quotes issue. Using %str(%') does not …

Read More
Is it possible to loop over SAS datasets?

I have 60 sas datasets that contain data on consumers individual characteristics such as id, gender, age, amountSpent, .... Each dataset shows data only for one time period (data1 is Jan, data2 is Feb...). I cannot merge them because of the size …

Read More
SAS: Calling one macro from another...Order of Macro Definitions

In my code I have several macros. Macro A is the main macro. Macro A then calls macro B which in turn calls macro C. In SAS, do I have to define them in backwards order? In other words, do …

Read More