ERROR HANDLING WITH FILE EXISTANCE

kumarsandip975 — Tue, 22 Nov 2022 07:19:04 GMT

Hi,

Can anyone suggest how to exit from program in case file does not exit. I have some other include statement, based on file existance, I need to proceed to next program call.

filename ip_file '&ip_folder.\&file.';
%if (%sysfunc(fexist(ip_file)) eq 0) %then %do;
%put ERROR: Physical file does not exist ==> &ip_folder.\&file. ;
%end;

%include "someother program/abcd.sas";

Re: ERROR HANDLING WITH FILE EXISTANCE

Kurt_Bremser — Tue, 22 Nov 2022 08:41:21 GMT

This

filename ip_file '&ip_folder.\&file.';

will fail because macro triggers do not resolve within single quotes.

You can use the FILEEXIST Function with the physical filename, so you can omit the FILENAME anyway. And you can test for existence, run the include, and put the message otherwise:

%if %sysfunc(fileexist(&ip_folder.\&file.)) %then %do;
  %include "someother program/abcd.sas";
%end;
%else %do;
  %put ERROR: Physical file does not exist ==> &ip_folder.\&file. ;
%end;

topic Re: ERROR HANDLING WITH FILE EXISTANCE in SAS Programming

ERROR HANDLING WITH FILE EXISTANCE

Re: ERROR HANDLING WITH FILE EXISTANCE