topic Aborting a Job on certain errors in SAS Data Management

Aborting a Job on certain errors

titan31 — Thu, 13 Apr 2017 11:56:27 GMT

Hi,

I want to run to abort a DI job on certain errors. I'm reading files stored in a location, and if the file doesn't exist, I'd like to abort the job and not run further steps. . I've got the aborting working for any errors encountered, but is there anyway to restrict it to just abort if it sees, ERROR: Physical file does not exist. I'm using the Return Code Check transformation to status handle the file reader, so if there's anyways to do it throug that, it'd be preferable than through BASE SAS.

Thanks

Re: Aborting a Job on certain errors

collinelliot — Fri, 14 Apr 2017 12:58:08 GMT

I'm not sure about the mechanism to abort, but you could use code to check for the existence of a file (which is the error you're getting) and then conditionally execute other code inside a macro only if the file is found. Some code I've used is shown below.

%macro check_for_file(dir); 

   %local rc fileref;
   %global file_found_flag;
   %let rc = %sysfunc(filename(fileref, &dir));
   %put Checking for existence of &dir;
   %if %sysfunc(fexist(&fileref))  %then %let file_found_flag=1;    
   %else %let file_found_flag=0;

%mend check_for_file;

%macro x(file);

%check_for_file(&file)

%if &file_found_flag = 1 %then %do;

%put The file exists. Run code...;

%end;
%else %do;

    %put The file was not found.;

%end;
%mend x;
%x(yourPath\yourFile)

Re: Aborting a Job on certain errors

LinusH — Sat, 15 Apr 2017 21:01:18 GMT

The functionality you're asking for is standard in most scheduling software. Use that, and shouldn't need to handle this in SAS at all.

Re: Aborting a Job on certain errors

SASKiwi — Sun, 16 Apr 2017 00:17:00 GMT

I prefer using general SAS options for SAS error checking and / or scheduler options as they are a lot easier and cope with most problems. The one I find most useful is the SAS option SYNTAXCHECK:

http://support.sas.com/documentation/cdl/en/lesysoptsref/69799/HTML/default/viewer.htm#n014qbvh3po8w5n1qlqbzr22vtg0.htm

With this option whenever SAS hits a significant error it goes into syntax check mode and doesn't process any data.