topic If Statements useing a macro variable created in a Macro in SAS Enterprise Guide

If Statements useing a macro variable created in a Macro

carlosnreis — Tue, 19 Sep 2017 14:56:45 GMT

Hi,

i have a problem in this code... the "IF" statement dont work... someone can help me?

The Macro Variable G_STATUS is created in this Macro

%macro CONSULTAR_TABELA(RELATORIO,BASE);
%GLOBAL G_STATUS;
%LOCAL STATUS;

proc sql;
SELECT T1.status INTO: STATUS

FROM CONTROLE.BASE_VALIDADOR T1
WHERE COMPRESS(RELATORIO) EQ &RELATORIO. AND COMPRESS(TABELA) EQ &BASE.
;
RUN;

%LET G_STATUS = &STATUS;
%mend CONSULTAR_TABELA;

and i would like to use this macro variable in this "IF" conditional:

data _NULL_;
%let RELATORIO = 'SOL';
%let TABELA = 'ZCRM_O02';

%CONSULTAR_TABELA(&RELATORIO,&TABELA);

%IF &g_status ="EM ATUALIZACAO" %then
x=1;
run;

The error is:

61 %IF &g_status ="EM ATUALIZACAO" %then
ERROR: The %IF statement is not valid in open code.
62 x=1;
63 run;

thanks for all

Re: If Statements useing a macro variable created in a Macro

Reeza — Tue, 19 Sep 2017 14:59:36 GMT

Well, the error is correct, macro logic is only good within a macro.

What are you trying to do? Yes, your code doesn't work, but without knowing what you're tyring to accomplish we can't offer a solution.

Re: If Statements useing a macro variable created in a Macro

Astounding — Tue, 19 Sep 2017 15:13:45 GMT

A couple of things to fix ...

First, your macro runs PROC SQL. You don't do that in the middle of a DATA step. So switch the order:

%let RELATORIO = 'SOL';
%let TABELA = 'ZCRM_O02';

%CONSULTAR_TABELA(&RELATORIO,&TABELA);

data _null_;

Next, even though %IF / %THEN is illegal, you don't really need it. You have started a DATA step, which uses IF / THEN (not %IF / %THEN). So you could use:

data _null_;

IF "&g_status" ="EM ATUALIZACAO" then x=1;

run;

If you merely want to examine the value of &G_STATUS instead of running a DATA step, you could simply use:

%put &G_STATUS;