topic Re: Making a DI Studio job fail when the input table is empty in SAS Data Management

Making a DI Studio job fail when the input table is empty

ENM — Fri, 21 Jun 2013 10:05:38 GMT

DI Studio question. I want to make sure that if an input table is empty, the job fails (triggers an ERROR) and stops running. How can this be accomplished?

P.S. Should be resolved without user written code.

Thanks for your time.

Re: Making a DI Studio job fail when the input table is empty

Patrick — Sat, 22 Jun 2013 02:23:56 GMT

If you want full control then I believe you would have to implement this either as pre-code in the node or as a custom transformation.

You could create a autocall macro for this and then simply call this autocall macro. Some nodes generate a macro "%etls_recordCheck" which could serve as a starting point to write such a macro.

Re: Making a DI Studio job fail when the input table is empty

BrunoMueller — Thu, 04 Jul 2013 15:00:34 GMT

SAS Data Integration Studio can be extended with your own user written transformations, so you would need to code it once and then just use it again and again. The code for such a transformation could look like this:

%macro myCheckData; 
  %global trans_rc;

  data _A_%sysfunc( compress(&transformID, .));
    set &_input(obs=1);
  run;

  %put NOTE: &=sysnobs &=syserr;

  %if &sysnobs = 1 %then %do; 
    %let trans_rc = 0;
    %put NOTE: OKOKOKOKOK;
  %end; 
  %else %do; 
    %let trans_rc = 8;
    %put NOTE: NOTOK NOTOK NOTOK NOTOK;
  %end; 

  %put NOTE: &sysmacroname &=trans_rc;
%mend; 

%myCheckData

You can use then the normal Return Code Check transformation.