topic Re: Enterprise Guide: conditional processing removed when exporting code in SAS Enterprise Guide

Enterprise Guide: conditional processing removed when exporting code

barry_van_dijk — Fri, 28 Jun 2019 09:39:17 GMT

Hi,

I have added conditional processing to a program in a process flow based on the day of the month: the program should execute on the 2nd day of the month only. This works without problems when running the code from within Enterprise Guide.

However, now I have exported the code to a .sas file and scheduled it to run in a batch process and the condition seems to be ignored during the export. I cannot track it in the execution log and also in the created .sas file I cannot find traces of it.

Can anyone help me on this please? Your help is greatly appreciated!

Re: Enterprise Guide: conditional processing removed when exporting code

Haris — Tue, 02 Jul 2019 19:01:08 GMT

Is it possible that your conditional processing is done in scheduler rather than SAS syntax itself? Another way SEG allows for conditional processing is via interactive user input. Can't tell how you programmed the conditional processing you're referencing.

Re: Enterprise Guide: conditional processing removed when exporting code

barry_van_dijk — Thu, 04 Jul 2019 08:59:30 GMT

Hello Haris,

Thank you for your reply!

The interactive user input you mentioned is not an option as the program is running as a batch in the Windows scheduler, so I cannot perform any user interaction.

The program just queries a database and sends an e-mail with the query results as an Ecxel attachment (see the code fragment below):

proc sql exec; 
	connect to odbc(datasrc="<datasource>" USER="<user>" PASSWORD="<password>"); 

	create table work.<dataset> as 
	select *
	from connection to odbc(


select
	...
from
	...
where
	...
;


)
	;

	disconnect from odbc; 
	quit; 
run; 

proc export 
data=work.<dataset>
outfile="<file path>"
dbms=xlsx replace;
run;

options emailsys = SMTP;
options emailhost = "<e-mail host>";
options emailauthprotocol = NONE;

filename anyname email
  to="<e-mail address>"
  from="<e-mail address>"
  sender="<e-mail address>"
  subject="<subject>"
  attach=("<file path>" content_type="application/xlsx");

data _null_;
 file anyname;
 put '<mail body>';
 run;

In attached zip file you will find a screenshot showing the way that the condition was added to the process flow. However, when exporting the program, this condition seems to be ignored.

Would you know another way to implement the condition in such a way that it gets included in the exported code?

Thanks, Barry

Re: Enterprise Guide: conditional processing removed when exporting code

TomKari — Thu, 04 Jul 2019 20:20:17 GMT

I just did some experimenting, and I can't see any way to get the conditional logic into the exported SAS code.

However, in the program that I am running conditionally, after I've run it, there is a tab called "Conditional Logic Log". It shows how EG transitions between your specified condition and a flag that EG uses to decide whether to run the program.

If you're comfortable with macro logic, you should be able to use that to derive the code that you need. If not, post it here and someone will be able to give you an example.

Tom

Re: Enterprise Guide: conditional processing removed when exporting code

barry_van_dijk — Fri, 05 Jul 2019 07:56:42 GMT

Hi Tom,

I found the following lines in the project log:

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          data _NULL_; rc = 0;
4          if day(date()) = day('2jun2019'd) then
5             rc = 1;
6          CALL SYMPUT('_egrc', PUT(rc,1.));
7          stop;
8          run;

NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      

9          
10         QUIT; RUN;
11

Is this what you are referring to?

As I am not comfortable with macro logic at all, I would be very happy if someone could help me further on this!

Best regards,

Barry

Re: Enterprise Guide: conditional processing removed when exporting code

TomKari — Fri, 05 Jul 2019 14:18:27 GMT

Yes, that's exactly what I was asking about!

I think this should do what you need; just put the code that you want executed conditionally between the %if and the %end statements (I used a proc print step).

Tom

data _NULL_;
	rc = 0;

	if day(date()) = day('2jun2019'd) then
		rc = 1;
	CALL SYMPUT('DateFlag', PUT(rc,1.));
	stop;
run;

%if &DateFlag = 1 %then %do;

/* Code to be run conditionally */

proc print data=sashelp.class;
run;

%end;

Re: Enterprise Guide: conditional processing removed when exporting code

barry_van_dijk — Tue, 09 Jul 2019 08:17:25 GMT

Thank you for your reply Tom! This works for me...

Barry

Re: Enterprise Guide: conditional processing removed when exporting code

CaseySmith — Tue, 16 Jul 2019 02:50:38 GMT

As you all noted, conditional logic added to a process flow does not currently get exported as SAS code. Manually coding conditional logic (as suggested) is the closest solution.

Casey