Date:         Tue, 19 Jan 2010 08:02:32 -0800
Reply-To:     Frank Poppe <Frank.Poppe@PWCONSULTING.NL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Frank Poppe <Frank.Poppe@PWCONSULTING.NL>
Organization: http://groups.google.com
Subject:      Error or Abort on invalid data
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I have a job in DI Studio that reads data from an external (CSV)
file.
This process is scheduled together with some other jobs.

Occasionally (or even more often) there is invalid data in one of the
fields. This causes NOTE's in the LOG, but the process continues.
I would like to have an error condition set, so that the process
aborts, or at least so that the scheduler will not start subsequent
processes.

I know that the _ERROR_ flag is set within the data step so that code
could be added there to abort. But there is no way that I know of to
accomplish that from within DI Studio, without changing to 'user
written code'. And that makes the code difficult to maintain in the
future.

Any ideas to force an abort, or at least a return code for the job
that prevents the scheduler from continuing?

Thanks

Frank Poppe
PW Consulting
the Netherlands