BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
saslover15
Obsidian | Level 7

The automation we are building is failing on job conditions.  At line 5, below, notice there is nothing in between the quotes of the "if" condition. It is null.   So the VB.net side that drives the run can't yet see what the condition is.   In the job condition in the SAS EG project, it says "If this condition is true:  "Include or Exclude Vendor equal to 'EXCLUDE'"  So we want the piece of hand-coding to run if the user chooses EXCLUDE.  Our automation can read the user picking EXCLUDE just fine.  But when it gets to the job condition, it can't read the SAS EG interface's job condition. 

 

How do we fix this so our automation can see this "if" condition???  Here is the log snippet with the missing if condition:

 

Log for "Condition Evaluation for Piece_of_Handcoding1." run at 8/11/2020 3:34:20 PM on MyServer
1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET INCL_EXCL = EXCLUDE;
4          data _NULL_; rc = 0;
5          if '' = 'EXCLUDE' then
6             rc = 1;
7          CALL SYMPUT('_egrc', PUT(rc,1.));
8          stop;
9          run;

1 ACCEPTED SOLUTION

Accepted Solutions
saslover15
Obsidian | Level 7

We solved this, in case anyone ever stumbles across this post.  The solution is to put on the VB.NET side,  'INCLUDE' = 'INCLUDE' (or 'EXCLUDE = 'EXCLUDE' if it is the exclude scenario).

View solution in original post

1 REPLY 1
saslover15
Obsidian | Level 7

We solved this, in case anyone ever stumbles across this post.  The solution is to put on the VB.NET side,  'INCLUDE' = 'INCLUDE' (or 'EXCLUDE = 'EXCLUDE' if it is the exclude scenario).

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 649 views
  • 0 likes
  • 1 in conversation