topic Check at each level in SAS Programming

Check at each level

SASPhile — Wed, 06 May 2009 19:25:04 GMT

Hi,
As part of process, I have to check if a physicians name is correctly given in the raw data with a lookup table that has correct physician's names and also on drugnames if they are spelled correctly.
If there is a physician whose name is not correctly spelled I will output a error dataset.
The check i want to do is, if the error dataset is created ,stop the process there, so that I can fix the physician's name and update the lookup table if a new physician comes for the current data and resume the process.

Re: Check at each level

JackHamilton — Wed, 06 May 2009 19:33:41 GMT

It will be easier to unconditionally create the error data set, and halt execution if the data set contains observations.

=====
data _null_;

set errors;

abort abend;

run;
=====

Will abort if there are errors, and continue merrily along with the error data set has observations.

Re: Check at each level

SASPhile — Wed, 06 May 2009 20:53:14 GMT

abort abend will exit out of the system.But all I need is to stop at that point so that I can check the error and start the process again.

By usig abort abend, I will have to login back to the sas system again.This will confuse the user I guess!

Re: Check at each level

sbb — Thu, 07 May 2009 01:05:49 GMT

In a DATA step, test the variable used with the NOBS= on the SET statement, and issue a STOP; statement if there are observations found in the ERRORS file.

Scott Barry
SBBWorks, Inc.