topic Re: use macro in if-else statement in SAS Programming

use macro in if-else statement

Geo- — Wed, 21 Mar 2018 04:11:24 GMT

when I merely used macro:

%extracTable();

there is no error..

however when I am using :

data _null_;

if 1=1

then %extracTable();

else put @@@do not insert@@@;

run;

it return :

error:unquote array:Execute

error:388-105

error 76-322

error:180-322

why and how to fix it...I am weak at sas Marco grammar..thank you

Re: use macro in if-else statement

ChrisNZ — Wed, 21 Mar 2018 04:25:35 GMT

Try:

if 1=1 then call execute('%extracTable();');

Re: use macro in if-else statement

Astounding — Wed, 21 Mar 2018 04:32:29 GMT

I'm not sure I should reply. You seem unwilling or perhaps unable to take my advice on other questions. So last attempt:

data _null_;

if 1=1

then call execute('%nrstr(%extracTable())');

else put '@@@do not insert@@@';

run;

It's not clear why you need an ELSE condition when 1=1 must always be true, but perhaps this is a simplification of a more complex problem.

Re: use macro in if-else statement

ChrisNZ — Wed, 21 Mar 2018 04:41:16 GMT

@Astounding I didn't see this thread was the continuation of another thread.

Maybe should it be marked as spam to remove duplicates?

Re: use macro in if-else statement

Geo- — Wed, 21 Mar 2018 04:45:58 GMT

thanks..I get the result right,but still an error :
ERROR 180-322:statement is not valid.
why and how to do..

Re: use macro in if-else statement

Geo- — Wed, 21 Mar 2018 04:46:58 GMT

thanks in advance..I get the result right,but still an error :
ERROR 180-322:statement is not valid.
why and how to do..

Re: use macro in if-else statement

Astounding — Wed, 21 Mar 2018 04:51:49 GMT

My preference is to just let it stand as is. I say that because the question has changed somewhat. One of my pet peeves is questions that morph as they are solved, and I would much rather avoid that.

"OK, that worked but what I really need is to ..."

"OK, that worked. The next step is to ..."

Let this part stand as a separate question, and chips fall where they may.

Re: use macro in if-else statement

Astounding — Wed, 21 Mar 2018 04:54:25 GMT

For someone to diagnose the error, you will need to post the log.

Re: use macro in if-else statement

ballardw — Wed, 21 Mar 2018 15:34:54 GMT

@Astounding wrote:

For someone to diagnose the error, you will need to post the log.

And perhaps the actual macro code that is called.

And run the code with: Options mprint symbolgen mlogic;

Then post the log with the code and error messages into a code box opened using the forum {I} menu icon. Error messages often have indicators of position where SAS identified the error but the main message windows of this forum will reformat text resulting in moved indicators. The code box will preserve text as copied from the log so the diagnostics are in the correct position.

Note that errors caused by macro code do not display in the most helpful manner unless the MPRINT option is set.