topic Re: Calling a Macro from an IF in SAS Enterprise Guide

Calling a Macro from an IF

JeffreyLowe — Thu, 04 Feb 2021 19:23:43 GMT

Good Day!

I am trying to call an email macro from an IF based on a stored value. I am sending to different individuals based on the setting of flag.

data _null_ ;

if flag = 'T" then ;

%genMail("tomail","ccmail","bcmail","subject","attachment","bodytext") ;

else ;

%genMail("tomail","ccmail","bcmail","subject","attachment","bodytext") ;

run ;

Re: Calling a Macro from an IF

Reeza — Thu, 04 Feb 2021 19:27:40 GMT

Your IF syntax is wrong you shouldn't have the semicolon between them. In that case, it ends your IF statement and each macro command will be executed.

data _null_ ;

if flag = 'T" then

%genMail("tomail","ccmail","bcmail","subject","attachment","bodytext") ;

else

%genMail("tomail","ccmail","bcmail","subject","attachment","bodytext") ;

run ;

In general though, I'd recommend creating a variable with the parameters and then using that with the macro call. Also, within a data step it's slightly cleaner to use CALL EXEUCTE() to call the macro. The documentation has a good example of CALL EXECUTE.

data _null_ ;

if flag = 'T" then ;

call execute('%genMail("tomail","ccmail","bcmail","subject","attachment","bodytext");') ;

else ;

call execute('%genMail("tomail","ccmail","bcmail","subject","attachment","bodytext");') ;

run ;

Re: Calling a Macro from an IF

PaigeMiller — Thu, 04 Feb 2021 19:34:48 GMT

Since the data step variable FLAG never equals "T", you will always execute the ELSE clause, but you have syntax errors and incorrect semi-colons.

data _null_ ;
     if flag = "T" then 
          %genMail("tomail","ccmail","bcmail","subject","attachment","bodytext") ;
     else 
          %genMail("tomail","ccmail","bcmail","subject","attachment","bodytext") ;
run ;

but I think you might really want a SET statement so FLAG has a value that might be "T"

data _null_ ;
    set somedataset;
     if flag = "T" then 
          %genMail("tomail","ccmail","bcmail","subject","attachment","bodytext") ;
     else 
          %genMail("tomail","ccmail","bcmail","subject","attachment","bodytext") ;
run ;

And then whatever %genmail does can only contain DATA step code, if there's a PROC in there, the whole thing fails.

But, there are lots of problems here. Whether FLAG="T" or not, you execute the same macro with the same arguments. Why?

Perhaps you ought to start over and explain what you are trying to do, rather than putting up such problematic code and have us guess what you are trying to do.

Re: Calling a Macro from an IF

PaigeMiller — Thu, 04 Feb 2021 19:30:18 GMT

Adding:

Yes, I agree with @Reeza , that CALL EXECUTE would be a better method of executing this macro if it doesn't contain valid DATA step code.

Re: Calling a Macro from an IF

JeffreyLowe — Thu, 04 Feb 2021 19:34:09 GMT

Actually flag is set elsewhere based on the data being processed when I entered my example it should say if &flag = 'T'..........

Re: Calling a Macro from an IF

JeffreyLowe — Thu, 04 Feb 2021 19:35:38 GMT

Thank you Paige!

Re: Calling a Macro from an IF

PaigeMiller — Thu, 04 Feb 2021 19:44:22 GMT

@JeffreyLowe wrote:

Actually flag is set elsewhere based on the data being processed when I entered my example it should say if &flag = 'T'..........

This syntax works only if the value of &FLAG is a character string with quotes around it ... in which case, why even bother with DATA _NULL_;? Do it all with macro %IF and not within a DATA step.

%if &flag=T %then ... ; /* Note, you don't put macro variable values in quotes */

Re: Calling a Macro from an IF

Reeza — Thu, 04 Feb 2021 19:57:47 GMT

As of SAS 9.4 M5+ (I think) you can use %IF in open code and no macro/data step is required.

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=mcrolref&docsetTarget=n18fij8dqsue9pn1lp8436e5mvb7.htm&locale=en

Re: Calling a Macro from an IF

PaigeMiller — Thu, 04 Feb 2021 22:20:02 GMT

@PaigeMiller wrote:

@JeffreyLowe wrote:

Actually flag is set elsewhere based on the data being processed when I entered my example it should say if &flag = 'T'..........

This syntax works only if the value of &FLAG is a character string with quotes around it ... in which case, why even bother with DATA _NULL_;? Do it all with macro %IF and not within a DATA step.
%if &flag=T %then ... ; /* Note, you don't put macro variable values in quotes */

Adding to the above ... if you really want to test &flag='T', this is a situation where double quotes and single quotes cannot be mixed and matched. If, for example, the value of &flag is "T", you will not get a match. Only if &flag is 'T' will you get a match, and this doesn't seem like a good way to do the comparison (which is one reason why I say macro variable values should not be enclosed in quotes).