FILEEXIST() should be able to test if a file exists. You could also try using the FOPEN() function. An easy way to test if a file has zero records is to read it. For example this will set the macro variable EMPTY to 1 when there are no records in the file referenced by the filename (or DD name on MVS) of MYFILE. %let empty=0; data _null_; if eof then call symputx('EMPTY','1'); infile MYFILE end=eof ; stop; run;
... View more