topic Re: How to use FEXIST in a data step? in SAS Programming

How to use FEXIST in a data step?

WesBarris — Wed, 10 Apr 2013 14:39:10 GMT

I would like to prevent an output file from SAS from being overwritten if that SAS program is run a second time. To do this I have assigned two filerefs using two FILENAME statements. Then in the data step that writes the output, I have tried to use the FEXIST function to test if the output file already exists. If it does, I would like to write the output to a second file. Here is some pseudo code I have written:

filename this "C:\this.dat";

filename that "C:\that.dat";

data here;

set there;

if (fexist("this")) then

file that;

else

file this;

put a b c d;

run;

When I use this code, the file "this.dat" is always written and the file "that.dat" is always zeroed out. What am I doing wrong?

Re: How to use FEXIST in a data step?

LinusH — Wed, 10 Apr 2013 14:42:31 GMT

You might be better off by checking this before the data step in a macro, and assign the appropriate file name to macro variable, and then avoiding having the explicit FILE statements for each file.

Re: How to use FEXIST in a data step?

data_null__ — Wed, 10 Apr 2013 15:41:32 GMT

You don't need macro you need FILEVAR.

filename this "~/this.dat"; 
filename that "~/that.dat"; 

data _null_; 
   length filevar $128; 
   if (fexist("this")) then filevar = pathname('that','F');
   else filevar = pathname('this','F');
   putlog filevar=;

   file dummy filevar=filevar dsd; 
   do while(not eof);
      set sashelp.class end=eof;
      put (_all_)(:); 
      end; 
   stop; 
   run; 

Re: How to use FEXIST in a data step?

WesBarris — Wed, 10 Apr 2013 17:04:59 GMT

Thank you. I was able to do what I needed using your advice and creating a macro.

Re: How to use FEXIST in a data step?

WesBarris — Wed, 10 Apr 2013 17:07:46 GMT

Data_null,

I was unable to get your solution to work. The first iteration of the data step would write to one file. Subsequent iterations would write to the other file. I was unable to understand what you were doing with that do while loop. I wasn't sure if that was something that I needed or not.

Re: How to use FEXIST in a data step?

data_null__ — Wed, 10 Apr 2013 17:14:45 GMT

The DO WHILE loop is the part that keeps it from doing what you don't want it to do but once (check for existence and open appropriate file). You are suppose to put your SET statement in the same place as mine.