SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Accepted Solution Solved
Reply
Occasional Contributor ENM
Occasional Contributor
Posts: 12
Accepted Solution

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

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. Smiley Happy


Accepted Solutions
Solution
‎07-04-2013 11:00 AM
SAS Super FREQ
Posts: 708

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

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.

View solution in original post


All Replies
Respected Advisor
Posts: 4,173

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

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.

Solution
‎07-04-2013 11:00 AM
SAS Super FREQ
Posts: 708

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

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.
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 667 views
  • 3 likes
  • 3 in conversation