DSNFERR option is set, but processing continues even after ERROR: - job returns RC=0

BobW_HBF_Oz — Thu, 11 May 2017 06:54:01 GMT

SAS 9.4

SAS DI Studio 4.901

I expected the DSNFERR option to return an RC of 8 if not finding a dataset to process.

I also expect it would not continue processing rows (except in SYNTAX CHECK mode).

Can someone suggest something that might be allowing the job to continue as normal after the ERROR: is noted in the log?

I might be missing an option, but we have checked the Batch Server as well as our workspace server to ensure the option is set, but still getting what I consider to be strange behaviour.

Cheers

Bob

Again FYI, this job has RC=0 and so we are missing capture of this ERROR.

<snip>

options DSNFERR;

166

167

168 /*Update Offence Hierarchy*/

169

170 proc sql;

170 ! update PROSEC.STI_BRIEFS_DATA as T1

171 set CATEGORY =

172 (select CATEGORY from PROSEC.ASOC_UNIQUE_TEEEEEEST as T2

173 where t1.STATUTE = t2.STATUTE)

174 ;

ERROR: File PROSEC.ASOC_UNIQUE_TEEEEEEST.DATA does not exist.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

175 quit;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

176

177 proc sql;

177 ! update PROSEC.STI_BRIEFS_DATA as T1

178 set OFFENCE =

179 (select OFFENCE from PROSEC.ASOC_UNIQUE as T2

180 where t1.STATUTE = t2.STATUTE)

181 ;

NOTE: 2686782 rows were updated in PROSEC.STI_BRIEFS_DATA.

182 quit;

NOTE: PROCEDURE SQL used (Total process time):

real time 37.96 seconds

cpu time 25.92 seconds

<snip/>

Re: DSNFERR option is set, but processing continues even after ERROR: - job returns RC=0

Patrick — Thu, 11 May 2017 12:05:47 GMT

@BobW_HBF_Oz

It's imho not intuitive that SAS doesn't remain in syntax check mode once it encounters the missing file - but that's how it is.

Using option ERRORABEND should resolve the issue for you.

Here some working code for testing.

/*options errorabend;*/
options noerrorabend;

options DSNFERR;
libname prosec (work);

data prosec.STI_BRIEFS_DATA;
  category=1;
  STATUTE=1;
  OFFENCE=.;
run;

proc sql;
  update PROSEC.STI_BRIEFS_DATA as T1
    set CATEGORY =
      (select CATEGORY from PROSEC.ASOC_UNIQUE_TEEEEEEST as T2
        where t1.STATUTE = t2.STATUTE)
  ;
quit;

data PROSEC.ASOC_UNIQUE;
  set prosec.STI_BRIEFS_DATA;
  OFFENCE=5;
run;

proc sql;
  update PROSEC.STI_BRIEFS_DATA as T1
    set OFFENCE =
      (select OFFENCE from PROSEC.ASOC_UNIQUE as T2
        where t1.STATUTE = t2.STATUTE)
  ;
quit;

topic DSNFERR option is set, but processing continues even after ERROR: - job returns RC=0 in SAS Data Management

DSNFERR option is set, but processing continues even after ERROR: - job returns RC=0

Re: DSNFERR option is set, but processing continues even after ERROR: - job returns RC=0